What's new for VBA in Office 2019
The following tables summarize the new Visual Basic for Applications (VBA) language updates for Office 2019.
Office
| Name | Description |
|---|---|
| MsoGraphicStyleIndex enumeration (Office) | Represents preset Graphic styles. |
| MsoShapeType enumeration (Office) | mso3DModel, msoGraphic, msoLinked3DModel, and msoLinkedGraphic values are now included. |
Access
| Name | Description |
|---|---|
| Chart object (Access) | A customizable visualization of data that can be included in a report or a form. |
| ChartAxis object (Access) | Represents a field whose values will be included in the category axis of a chart. |
| ChartSeries object (Access) | Represents a series of values in the specified chart. |
| ChartValues object (Access) | Represents a field whose values will be plotted in the value (Y) axis of a chart. |
| acCommand enumeration (Access) | acCmdImportAttachdBase and acCmdExportdBase values are now included. |
Excel
| Name | Description |
|---|---|
| Model3DFormat object (Excel) | Represents the properties of a 3D model shape. |
| Series.GeoMappingLevel property (Excel) | Specifies the geography mapping level for the specified series within the chart group. Read/write XlGeoMappingLevel. |
| Series.GeoProjectionType property (Excel) | Specifies the geography projection type for the specified series within the chart group. Read/write XlGeoProjectionType. |
| Series.RegionLabelOptions property (Excel) | Specifies the region labelling behavior for the specified series within the chart group. Read/write XlRegionLabelOptions. |
| Shape.GraphicStyle property (Excel) | Returns or sets an MsoGraphicStyleIndex that represents the style of an SVG graphic. Read/write. |
| Shape.Model3D property (Excel) | Returns a Model3DFormat object that represents the 3D properties of a 3D model object. Read-only. |
| ShapeRange.GraphicStyle property (Excel) | Returns or sets an MsoGraphicStyleIndex that represents the style of a shape range containing one or more SVG graphics. Read/write. |
| ShapeRange.Model3D property (Excel) | Returns a Model3DFormat object that represents the 3D properties of a 3D model object. Read-only. |
| Shapes.Add3DModel method (Excel) | Creates a 3D model from an existing file. Returns a Shape object that represents the new 3D model. |
| Excel.XlGeoMappingLevel enumeration (Excel) | Constants passed to and returned by the Series.GeoMappingLevel property. |
| Excel.XlGeoProjectionType enumeration (Excel) | Constants passed to and returned by the Series.GeoProjectionType property. |
| Excel.XlRegionLabelOptions enumeration (Excel) | Constants passed to and returned by the Series.RegionLabelOptions property. |
PowerPoint
| Name | Description |
|---|---|
| Model3DFormat object (PowerPoint) | Represents the properties of a 3D model shape. |
| Presentation.AutoSaveOn property (PowerPoint) | True if the edits in the presentation are automatically saved. Read/write Boolean. |
| Shape.Decorative property (PowerPoint) | Sets or returns the decorative flag for the specified object. Read/write. |
| Shape.GraphicStyle property (PowerPoint) | Returns or sets an MsoGraphicStyleIndex that represents the style of an SVG graphic. Read/write. |
| Shape.Model3D property (PowerPoint) | Returns a Model3DFormat object that represents the 3D properties of a 3D model object. Read-only. |
| ShapeRange.Decorative property (PowerPoint) | Sets or returns the decorative flag for the specified object. Read/write. |
| ShapeRange.GraphicStyle property (PowerPoint) | Returns or sets an MsoGraphicStyleIndex that represents the style of a shape range containing one or more SVG graphics. Read/write. |
| ShapeRange.Model3D property (PowerPoint) | Returns a Model3DFormat object that represents the 3D properties of a 3D model object. Read-only. |
| Shapes.Add3DModel method (PowerPoint) | Creates a Model3DFormat object from an existing file. Returns a Shape object that represents the new 3D model. |
Visio
| Name | Description |
|---|---|
| Shape.AlternativeText property (Visio) | Returns or sets the alternative text description associated with an object. Read/write. |
| Shape.Title property (Visio) | Returns or sets the alternative text associated with an object. Read/write. |
Word
| Name | Description |
|---|---|
| Model3DFormat object (Word) | Represents the properties of a 3D model shape. |
| Shape.GraphicStyle property (Word) | Returns or sets an MsoGraphicStyleIndex that represents the style of an SVG graphic. Read/write. |
| Shape.Model3D property (Word) | Returns a Model3DFormat object that represents the 3D properties of a 3D model object. Read-only. |
| ShapeRange.GraphicStyle property (Word) | Returns or sets an MsoGraphicStyleIndex that represents the style of a shape range containing one or more SVG graphics. Read/write. |
| ShapeRange.Model3D property (Word) | Returns a Model3DFormat object that represents the 3D properties of a 3D model object. Read-only. |
| Shapes.Add3DModel method (Word) | Adds a 3D model to a drawing canvas. Returns a Shape object that represents the 3D model and adds it to the CanvasShapes collection. |
| WdInlineShapeType enumeration (Word) | wdInlineShape3DModel and wdInlineShapeLinked3DModel values are now included. |
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for