Edit

What's new for VBA in Office 2016

  • Article

The following tables summarize the new VBA language updates for Office 2016.

Access

Name Description
CodeProject.IsSQLBackend property (Access) Returns the Boolean value True if the code project was created in Access 2013 and newer, and False if otherwise.
CurrentProject.IsSQLBackend property (Access) Returns True if the current project was created in Access 2013 and onwards and False if the current project was created prior to Access 2013. Read-only Boolean.

Excel

Name Description
Chart.ShowExpandCollapseEntireFieldButtons property (Excel) True to display the Expand Entire Field and Collapse Entire Field buttons on the specified PivotChart. Read/write Boolean.
ChartGroup.BinsCountValue property (Excel) Specifies the number of bins in the histogram chart. Read/write Long.
ChartGroup.BinsOverflowEnabled property (Excel) Specifies whether a bin for values above the BinsOverflowValue is enabled. Read/write Boolean.
ChartGroup.BinsOverflowValue property (Excel) If an BinsOverflowEnabled is True, specifies the value above which an overflow bin is displayed. Read/write Double.
ChartGroup.BinsType property (Excel) Specifies how the horizontal axis of the histogram chart is formatted, by bins type. Read/write XlBinsType.
ChartGroup.BinsUnderflowEnabled property (Excel) Specifies whether a bin for values below the BinsUnderflowValue is enabled. Read/write Boolean.
ChartGroup.BinsUnderflowValue property (Excel) If an BinsUnderflowEnabled is True, specifies the value below which an underflow bin is displayed. Read/write Double.
ChartGroup.BinWidthValue property (Excel) Specifies the number of points in each range. Read/write Double.
CubeField.AutoGroup method (Excel) Automatically groups the cube fields in an OLAP cube, optionally in the specified orientation and/or at the specified position.
Model.ModelFormatBoolean property (Excel) Returns a ModelFormatBoolean object that represents formatting of type true/false in the data model. Read-only.
Model.ModelFormatCurrency property (Excel) Returns a ModelFormatCurrency object that represents formatting of type currency in the data model. Read-only.
Model.ModelFormatDate property (Excel) Returns a ModelFormatDate object that represents formatting of type date in the data model. Read-only.
Model.ModelFormatDecimalNumber property (Excel) Returns a ModelFormatDecimalNumber object that represents formatting of type decimal number in the data model. Read-only.
Model.ModelFormatGeneral property (Excel) Returns a ModelFormatGeneral object that represents formatting of type general in the data model. Read-only.
Model.ModelFormatPercentageNumber property (Excel) Returns a ModelFormatPercentageNumber object that represents formatting of type percentage number in the data model. Read-only.
Model.ModelFormatScientificNumber property (Excel) Returns a ModelFormatScientificNumber object that represents formatting of type scientific number in the data model. Read-only.
Model.ModelFormatWholeNumber property (Excel) Returns a ModelFormatWholeNumber object that represents formatting of type whole number in the data model. Read-only.
Model.ModelMeasures property (Excel) Returns a ModelMeasures object that represents the collection of model measures in the data model. Read-only.
ModelConnection.CalculatedMembers property (Excel) Returns a CalculatedMembers object that represents the calculated members in the model connection.
ModelFormatBoolean object (Excel) Represents the format to be used for a model measure in the data model.
ModelFormatBoolean.Application property (Excel) When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
ModelFormatBoolean.Creator property (Excel) Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
ModelFormatBoolean.Parent property (Excel) Returns the parent object for the specified object. Read-only.
ModelFormatCurrency object (Excel) Represents the format to be used for a model measure in the data model.
ModelFormatCurrency.Application property (Excel) When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
ModelFormatCurrency.Creator property (Excel) Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
ModelFormatCurrency.DecimalPlaces property (Excel) Specifies the number of decimal places after the dot. Read/write Long.
ModelFormatCurrency.Parent property (Excel) Returns the parent object for the specified object. Read-only
ModelFormatCurrency.Symbol property (Excel) Specifies the symbol to use to represent the currency. Read/write String.
ModelFormatDate object (Excel) Represents the format to be used for a model measure in the data model.
ModelFormatDate.Application property (Excel) When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
ModelFormatDate.Creator property (Excel) Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
ModelFormatDate.FormatString property (Excel) Specifies the date format, for example, " dd/mm/yy ". Read/write String.
ModelFormatDate.Parent property (Excel) Returns the parent object for the specified object. Read-only.
ModelFormatDecimalNumber object (Excel) Represents the format to be used for a model measure in the data model.
ModelFormatDecimalNumber.Application property (Excel) When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
ModelFormatDecimalNumber.Creator property (Excel) Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
ModelFormatDecimalNumber.DecimalPlaces property (Excel) Specifies the number of decimal places after the dot. Read/write Long.
ModelFormatDecimalNumber.Parent property (Excel) Returns the parent object for the specified object. Read-only.
ModelFormatDecimalNumber.UseThousandSeparator property (Excel) Specifies whether to display commas between thousands. Read/write Boolean.
ModelFormatGeneral object (Excel) Represents the format to be used for a model measure in the data model.
ModelFormatGeneral.Application property (Excel) When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
ModelFormatGeneral.Creator property (Excel) Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
ModelFormatGeneral.Parent property (Excel) Returns the parent object for the specified object. Read-only.
ModelFormatPercentageNumber object (Excel) Represents the format to be used for a model measure in the data model.
ModelFormatPercentageNumber.Application property (Excel) When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
ModelFormatPercentageNumber.Creator property (Excel) Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
ModelFormatPercentageNumber.DecimalPlaces property (Excel) Specifies the number of decimal places after the dot. Read/write Long.
ModelFormatPercentageNumber.Parent property (Excel) Returns the parent object for the specified object. Read-only.
ModelFormatPercentageNumber.UseThousandSeparator property (Excel) Specifies whether to display commas between thousands. Read/write Boolean.
ModelFormatScientificNumber object (Excel) Represents the format to be used for a model measure in the data model.
ModelFormatScientificNumber.Application property (Excel) When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
ModelFormatScientificNumber.Creator property (Excel) Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
ModelFormatScientificNumber.DecimalPlaces property (Excel) Specifies the number of decimal places after the dot. Read/write Long.
ModelFormatScientificNumber.Parent property (Excel) Returns the parent object for the specified object. Read-only.
ModelFormatWholeNumber object (Excel) Represents the format to be used for a model measure in the data model.
ModelFormatWholeNumber.Application property (Excel) When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
ModelFormatWholeNumber.Creator property (Excel) Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
ModelFormatWholeNumber.Parent property (Excel) Returns the parent object for the specified object. Read-only.
ModelFormatWholeNumber.UseThousandSeparator property (Excel) Specifies whether to display commas between thousands. Read/write Boolean.
ModelMeasure object (Excel) Represents a single ModelMeasure object in the ModelMeasures collection.
ModelMeasure.Application property (Excel) When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
ModelMeasure.AssociatedTable property (Excel) Specifies the table that contains the model measure, as displayed in the Field List task pane. Read/writeModelTable.
ModelMeasure.Creator property (Excel) Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
ModelMeasure.Delete method (Excel) Deletes the model measure from the data model.
ModelMeasure.Description property (Excel) The description of the model measure. Read/write String.
ModelMeasure.FormatInformation property (Excel) The format of the model measure. Read/write Variant.
ModelMeasure.Formula property (Excel) The Data Analysis Expressions (DAX) formula of the model measure. Read/write String.
ModelMeasure.Name property (Excel) The name of the model measure. Read/write String.
ModelMeasure.Parent property (Excel) Returns the parent object for the specified object. Read-only.
ModelMeasures object (Excel) Represents: a collection of ModelMeasure objects.
ModelMeasures.Add method (Excel) Adds a model measure to the model.
ModelMeasures.Application property (Excel) When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
ModelMeasures.Count property (Excel) Returns an integer that represents the number of objects in the collection.
ModelMeasures.Creator property (Excel) Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
ModelMeasures.Item method (Excel) Returns a single object from a collection
ModelMeasures.Parent property (Excel) Returns the parent object for the specified object. Read-only.
ModelRelationships.DetectRelationships method (Excel) Detects model relationships in the specified PivotTable.
PivotField.AutoGroup method (Excel) Automatically groups the pivot fields in a PivotTable.
Point.IsTotal property (Excel) True if the point represents a total. Read/write Boolean.
Queries object (Excel) The collection of WorkbookQuery objects
Queries.Add method (Excel) Adds a new WorkbookQuery object to the Queries collection.
Queries.Application property (Excel) When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
Queries.Count property (Excel) Returns an integer that represents the number of objects in the collection.
Queries.Creator property (Excel) Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
Queries.FastCombine property (Excel) True to enable the fast combine feature, as long as the workbook is open. Read/write Boolean.
Queries.Item method (Excel) Returns a single object from a collection.
Queries.Parent property (Excel) Returns the parent object for the specified object. Read-only.
Series.ParentDataLabelOption property (Excel) Specifies the parent data label option (banner, overlapping, or none) for the specified series within the chart group. Read/write XLParentDataLabelOptions.
Series.QuartileCalculationInclusiveMedian property (Excel) True if the series uses an inclusive median quartile calculation method. Read/write Boolean.
SoundNote object (Excel) Represents a recorded sound note.
SoundNote.Application property (Excel) When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
SoundNote.Creator property (Excel) Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
SoundNote.Parent property (Excel) Returns the parent object for the specified object. Read-only.
SoundNote.Delete method (Excel) Deletes the sound note.
SoundNote.Import method (Excel) Imports the specified sound note.
SoundNote.Play method (Excel) Plays the sound note.
SoundNote.Record method (Excel) Records the sound note.
Workbook.CreateForecastSheet method (Excel) If you have historical time-based data, you can use CreateForecastSheet to create a forecast. When you create a forecast, a new worksheet is created that contains a table of the historical and predicted values and a chart showing this. A forecast can help you predict things like future sales, inventory requirements, or consumer trends.
WorkbookQuery object (Excel) An object that represents a query that was created by Power Query.
WorkbookQuery.Application property (Excel) When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
WorkbookQuery.Creator property (Excel) Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
WorkbookQuery.Delete method (Excel) Deletes this query and its underlying connection and removes it from the Queries collection.
WorkbookQuery.Description property (Excel) The description of the query. Read/write String.
WorkbookQuery.Formula property (Excel) The Power Query M formula for the object. Read-only String.
WorkbookQuery.Name property (Excel) The name of the query. Read/write String.
WorkbookQuery.Parent property (Excel) Returns the parent object for the specified object. Read-only.
WorksheetFunction.Forecast_ETS method (Excel) Calculates or predicts a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm.
WorksheetFunction.Forecast_ETS_ConfInt method (Excel) Returns a confidence interval for the forecast value at the specified target date.
WorksheetFunction.Forecast_ETS_Seasonality method (Excel) Returns the length of the repetitive pattern Excel detects for the specified time series.
WorksheetFunction.Forecast_ETS_STAT method (Excel) Returns a statistical value as a result of time series forecasting.
WorksheetFunction.Forecast_Linear method (Excel) Calculates, or predicts, a future value by using existing values. The predicted value is a y-value for a given x-value. The known values are existing x-values and y-values, and the new value is predicted by using linear regression. Use this function to predict future sales, inventory requirements, or consumer trends.
XlBinsType enumeration (Excel) Constants passed to and returned by the ChartGroup.BinsType property.
XlForecastAggregation enumeration (Excel) Constants passed to various WorksheetFunction and Workbook statistical forecasting methods.
XlForecastChartType enumeration (Excel) Constants passed to the Workbook.CreateForecastSheet Method.
XlForecastDataCompletion enumeration (Excel) Constants passed to various WorksheetFunction and Workbook statistical forecasting methods.
XlParentDataLabelOptions enumeration (Excel) Constants passed to and returned by the Series.ParentDataLabelOption property.

Outlook

Name Description
ExchangeDistributionList.GetUnifiedGroup method (Outlook) Determines if the object is a unified group, by way of a call to IsUnifiedGroup
ExchangeDistributionList.GetUnifiedGroupFromStore method (Outlook) Determines if the object is a unified group (by way of a call to IsUnifiedGroup) and returns the Outlook.Folder object associated with the group using the GetUnifiedGroup and GetUnifiedGroupFromStore methods.
ExchangeDistributionList.IsUnifiedGroup method (Outlook) Determines if the object is a unified group.
ExchangeUser.GetUnifiedGroup method (Outlook) Determines if the object is a unified group, by way of a call to IsUnifiedGroup.
ExchangeUser.GetUnifiedGroupFromStore method (Outlook) Determines if the object is a unified group, by way of a call to IsUnifiedGroup.
ExchangeUser.IsUnifiedGroup method (Outlook) Determines if the object is a unified group.
Explorer.DisplayMode property (Outlook) Indicates the display mode: Normal, Portrait View, or Portrait Reading Pane.
Explorer.DisplayModeChange event (Outlook) Occurs when the user performs an action that changes the display mode. Possible modes include Normal, Portrait View, and Portrait Reading Pane.
Explorer.PreviewPane property (Outlook) The PreviewPane object displays content in a "single pane mode" by showing only the Preview Pane view.
ExplorerEvents_10.DisplayModeChange method (Outlook) Occurs when the user performs an action that changes the display mode. Possible modes include Normal, Portrait View, and Portrait Reading Pane.
OlDisplayMode enumeration (Outlook) Describes the nature of the display mode. Possible modes include Normal, Portrait View, and Portrait Reading Pane.
OlUnifiedGroupFolderType enumeration (Outlook) Specifies the folder to be obtained for unified groups. Because groups have both a mail and a calendar folder, you can specify either the olGroupMailFolder or olGroupCalendarFolder.
OlUnifiedGroupType enumeration (Outlook) Specifies the group type as public or private for the CreateUnifiedGroup method.
PreviewPane members (Outlook) Displays content in a "single pane mode" by showing only the Preview Pane view.
PreviewPane object (Outlook) Displays content in a "single pane mode" by showing only the Preview Pane view.
PreviewPane.Application property (Outlook) Returns the Application object that represents the parent application (Outlook) for the PreviewPane Object. Read-only.
PreviewPane.Class property (Outlook) Returns a constant in the OlObjectClass enumeration indicating the class of the PreviewPane Object. Read-only.
PreviewPane.Parent property (Outlook) Returns the parent property for the PreviewPane Object. Read only.
PreviewPane.Session property (Outlook) Returns the NameSpace for the current session. Read-only.
PreviewPane.WordEditor property (Outlook) Returns the Microsoft Word Document Object Model of the message being displayed. Read-only.
Store.CreateUnifiedGroup method (Outlook) Enables a unified group to be created.
Store.DeleteUnifiedGroup method (Outlook) Enables a unified group to be deleted.

Project

Name Description
Application.AddEngagement method (Project) Adds a Resource Plan view, enabling users to display and edit engagement data to Project when connected to Project Online. Introduced in Office 2016.
Application.EngagementInfo method (Project) Displays the engagement information dialog box user interface for the Resource Plan view. Introduced in Office 2016.
Application.GetDpiScaleFactor method (Project) Indicates the DPI Scale Factor, used for optimizing scale settings. Introduced in Office 2016.
Application.InsertTimelineBar method (Project) Adds a timeline bar to the view.
Application.Inspector method (Project) Indicates the Task Inspector for use with engagement data.
Application.LocaleName method (Project) Language name that is used by Project, such as en-us or za-ch.
Application.ProjectSummaryInfoEx method (Project) Returns information about project summary, including the Project Utilization type and Project Utilization date information.
Application.RefreshEngagementsForProject method (Project) Refreshes the engagements for the project using engagement state on the server.
Application.RemoveTimelineBar method (Project) Removes a Timeline bar from the view.
Application.SubmitAllEngagementsForProject method (Project) Submits all the engagements in the project to the resource manager for review.
Application.SubmitSelectedEngagementsForProject method (Project) Submits all selected engagements in the project to the resource manager for review.
Application.TaskOnTimelineEx method (Project) Manages tasks on the Timeline pane or for a specified custom timeline, including specifying the bar that you want to add or remove.
Application.TimelineBarDateRange method (Project) Modifies the start and finish dates for a Timeline bar.
Application.UpdateEngagementsForProject method (Project) Update the Engagements for a Project.
Assignment.Compliant property (Project) Gets the compliant for a task assignment in Project. Read-only.
Cell.Engagement property (Project) Gets or sets the engagement resource for a cell.
Chart members (Project) The Chart object represents a chart on a report in Project.
Engagement object (Project)
Engagement.Application property (Project)
Engagement.Comments property (Project)
Engagement.CommittedFinish property (Project)
Engagement.CommittedMaxUnits property (Project)
Engagement.CommittedStart property (Project)
Engagement.CommittedWork property (Project)
Engagement.CreatedDate property (Project)
Engagement.Delete method (Project)
Engagement.DraftFinish property (Project)
Engagement.DraftMaxUnits property (Project)
Engagement.DraftStart property (Project)
Engagement.DraftWork property (Project)
Engagement.GetField method (Project)
Engagement.Guid property (Project)
Engagement.Index property (Project)
Engagement.ModifiedByGuid property (Project)
Engagement.ModifiedByName property (Project)
Engagement.ModifiedDate property (Project)
Engagement.Name property (Project)
Engagement.Parent property (Project)
Engagement.ProjectGuid property (Project)
Engagement.ProjectName property (Project)
Engagement.ProposedFinish property (Project)
Engagement.ProposedMaxUnits property (Project)
Engagement.ProposedStart property (Project)
Engagement.ProposedWork property (Project)
Engagement.ResourceGuid property (Project)
Engagement.ResourceID property (Project)
Engagement.ResourceName property (Project)
Engagement.ReviewedByGuid property (Project)
Engagement.ReviewedByName property (Project)
Engagement.ReviewedDate property (Project)
Engagement.SetField method (Project)
Engagement.Status property (Project)
Engagement.SubmittedByGuid property (Project)
Engagement.SubmittedByName property (Project)
Engagement.SubmittedDate property (Project)
EngagementComment members (Project)
EngagementComment object (Project)
EngagementComment properties (Project)
EngagementComment.Application property (Project)
EngagementComment.AuthorResEmail property (Project)
EngagementComment.AuthorResGuid property (Project)
EngagementComment.AuthorResName property (Project)
EngagementComment.CreatedDate property (Project)
EngagementComment.Guid property (Project)
EngagementComment.Message property (Project)
EngagementComment.Parent property (Project)
EngagementComments members (Project)
EngagementComments methods (Project)
EngagementComments object (Project)
EngagementComments properties (Project)
EngagementComments.Add method (Project)
EngagementComments.Application property (Project)
EngagementComments.Count property (Project)
EngagementComments.Item property (Project)
EngagementComments.Parent property (Project)
Engagements members (Project)
Engagements methods (Project)
Engagements object (Project)
Engagements properties (Project)
Engagements.Add method (Project)
Engagements.Application property (Project)
Engagements.Count property (Project)
Engagements.Item property (Project)
Engagements.Parent property (Project)
Engagements.UniqueID property (Project)
PjAssignmentWarnings enumeration (Project) Defines the different types of warnings that may appear on assignments triggering indicators in the indicator column in sheet views.
PjEngagementViolationType enumeration (Project) Defines the different types of engagement violation types triggering indicators in the indicator column in sheet views on tasks/resources and assignments. Used internally for setting the right violation types on tasks and resources.
PjEngagementWarnings enumeration (Project) Defines the different types of warnings that may appear on engagements triggering indicators in the indicator column in sheet views.
PjResourceWarnings enumeration (Project) Defines the different types of warnings that may appear on resources triggering indicators in the indicator column in sheet views.
Project.Engagements property (Project) Returns the root object for all Engagement properties.
Project.LastWssSyncDate property (Project) Returns the last date on which Project was synced with Wss. Read-only DateType.
Project.Timeline property (Project) Returns the root object for all Timeline properties. Read/write object.
Project.UtilizationDate property (Project) Used for portfolio analysis, such as Project Plan, Resource Engagements, or Project Plan until. Read-only. Project Plan uses the project plan to calculate resource availability, Resource Engagements uses Resource Engagements, and Project Plan until is a combination of Project Plan and Resource Engagements.
Project.UtilizationType property (Project) If the Project.UtilizationType property (Project) property is Project Plan until, this date is used to switch between using the project plan to calculate resource availability or when resource engagements are used. Read-only.
Resource.Compliant property (Project) True if the resource is compliant with its engagement. Read/write Boolean.
Resource.EngagementCommittedFinish property (Project) Returns the committed finish date for the engagement. Read-only DateType.
Resource.EngagementCommittedMaxUnits property (Project) Returns the committed max units for the engagement. Read-only Integer.
Resource.EngagementCommittedStart property (Project) Returns the committed start date for the engagement. Read-only DateType.
Resource.EngagementCommittedWork property (Project) Returns the committed work for the engagement. Read-only Double.
Resource.EngagementDraftFinish property (Project) Returns the draft finish date for the engagement. Read-only DateType.
Resource.EngagementDraftMaxUnits property (Project) Returns the draft max units for the engagement. Read-only Integer.
Resource.EngagementDraftStart property (Project) Returns the draft start date for the engagement. Read-only DateType.
Resource.EngagementDraftWork property (Project) Returns the draft work for the engagement. Read-only Double.
Resource.EngagementProposedFinish property (Project) Returns the proposed finish date for the engagement. Read-only DateType.
Resource.EngagementProposedMaxUnits property (Project) Returns the proposed maximum units for the engagement. Read-only Integer.
Resource.EngagementProposedStart property (Project) Returns the proposed start date for the engagement. Read-only DateType.
Resource.EngagementProposedWork property (Project) Returns the proposed work for the engagement. Read-only Double.
Resource.IsLocked property (Project) Indicates whether the resource is or is not locked. If resource is locked, you need an engagement for a resource. Read-only Return Boolean.
Task.Compliant property (Project)
Timeline members (Project)
Timeline object (Project)
Timeline properties (Project)
Timeline.Application property (Project) Gets the Project Application object.
Timeline.BarCount property (Project) Indicates the number of bars in a Timeline view.
Timeline.FinishDate property (Project) Indicates the finish date for a Timeline bar based on the input argument.
Timeline.Label property (Project) Returns the timeline for the Timeline object.
Timeline.StartDate property (Project) Indicates the start date for a Timeline bar based on the input argument.

PowerPoint

Name Description
ChartGroup.BinsCountValue property (PowerPoint) Specifies the number of bins in the histogram chart. Read/write Long.
ChartGroup.BinsOverflowEnabled property (PowerPoint) Specifies whether a bin for values above the ChartGroup.BinsOverflowValue property (PowerPoint) is enabled. Read/write Boolean.
ChartGroup.BinsOverflowValue property (PowerPoint) If an ChartGroup.BinsOverflowEnabled property (PowerPoint) is True, specifies the value above which an overflow bin is displayed. Read/write Double.
ChartGroup.BinsType property (PowerPoint) Specifies how the horizontal axis of the histogram chart is formatted, by bins type. Read/write XlBinsType Enumeration (PowerPoint).
ChartGroup.BinsUnderflowEnabled property (PowerPoint) Specifies whether a bin for values below the ChartGroup.BinsUnderflowValue property (PowerPoint) is enabled. Read/write Boolean.
ChartGroup.BinsUnderflowValue property (PowerPoint) If ChartGroup.BinsUnderflowEnabled property (PowerPoint) is True, specifies the value below which an underflow bin is displayed. Read/write Double.
ChartGroup.BinWidthValue property (PowerPoint) Specifies the number of points in each range. Read/write Double.
DocumentWindow.ShowInsertAppDialog method (PowerPoint)
Point.IsTotal property (PowerPoint) True if the point represents a total. Read/write Boolean.
Series.ParentDataLabelOption property (PowerPoint) Specifies the parent data label option (banner, overlapping, or none) for the specified series within the chart group. Read/write XlParentDataLabelOptions Enumeration (PowerPoint).
Series.QuartileCalculationInclusiveMedian property (PowerPoint) True if the series uses an inclusive median quartile calculation method. Read/write Boolean.
Shape.HasInkXML property (PowerPoint) Returns an MsoTriState enumeration value that indicates whether the specified shape contains ink XML that can be retrieved via the Shape.InkXML property. Read-only. An error is returned if the shape does not contain any ink XML.
Shape.InkXML property (PowerPoint) Returns a String that contains the InkActionML associated with the specified shape. Read-only. If the specified shape does not contain a ink object more than one ink object occurs , an error is returned.
Shape.IsNarration property (PowerPoint) Specifies whether the specified shape range contains a narration. Read/write.
ShapeRange.HasInkXML property (PowerPoint) Returns an MsoTriState enumeration value that indicates whether the specified shape range contains ink XML that can be retrieved via the ShapeRange.InkXML property. Read-only. An error is returned if the shape range does not contain any ink XML.
ShapeRange.InkXML property (PowerPoint) Returns a String that contains the InkActionML associated with the specified shape range. Read-only. If the specified shape range does not contain a ink object more than one ink object occurs , an error is returned.
ShapeRange.IsNarration property (PowerPoint) Specifies whether the specified shape range contains a narration. Read/write.
Shapes.AddInkShapeFromXML method (PowerPoint) Creates an ink shape. Returns a Shape object that represents the new ink shape.
SlideShowView.LaserPointerEnabled property (PowerPoint) Returns True if the current slide show pointer is a laser pointer. This property is applicable only while the slide show is running. Read/write. This property allows a user to programmatically query and set the state of the pointer shown during slide show. The property will return false for all other pointer types. Users can also change the state of the current pointer by setting this property to True to turn on the laser pointer or False to turn off the laser pointer.
XlBinsType enumeration (PowerPoint) Constants passed to and returned by the ChartGroup.BinsType property.
XlParentDataLabelOptions enumeration (PowerPoint) Constants passed to and returned by the Series.ParentDataLabelOption property.

Visio

Name Description
Document.Permission property (Visio)
IVInvisibleApp.Application property (Visio)
IVKeyboardEvent.Application property (Visio)
IVMouseEvent.Application property (Visio)
Master.VisualBoundingBox method (Visio) Returns the bounding rectangle of the virtual container that has all the shapes of the given master.
Page.VisualBoundingBox method (Visio) Returns the bounding rectangle of the virtual container that has all the shapes of the given page.
Selection.VisualBoundingBox method (Visio) Returns the bounding rectangle of the virtual container that has all the shapes of the given selection.
Shape.VisualBoundingBox method (Visio) Returns the bounding rectangle of the given shape.
ValidationIssues.Stat property (Visio)
VisColoringMethod enumeration (Visio)
VisRecordsetFieldStatus enumeration (Visio)

Word

Name Description
ChartGroup.BinsCountValue property (Word) Specifies the number of bins in the histogram chart. Read/write Long.
ChartGroup.BinsOverflowEnabled property (Word) Specifies whether a bin for values above the BinsOverflowValue is enabled. Read/write Boolean.
ChartGroup.BinsOverflowValue property (Word) If an BinsOverflowEnabled is True, specifies the value above which an overflow bin is displayed. Read/write Double.
ChartGroup.BinsType property (Word) Specifies how the horizontal axis of the histogram chart is formatted, by bins type. Read/write XlBinsType.
ChartGroup.BinsUnderflowEnabled property (Word) Specifies whether a bin for values below the BinsUnderflowValue is enabled. Read/write Boolean.
ChartGroup.BinsUnderflowValue property (Word) If an BinsUnderflowEnabled is True, specifies the value below which an underflow bin is displayed. Read/write Double.
ChartGroup.BinWidthValue property (Word) Specifies the number of points in each range. Read/write Double.
CoAuthUpdates object (Word) A collection of CoAuthUpdate objects that represent the updates that were merged into the document at the last explicit save.
Options.UseLocalUserInfo property (Word)
Point.IsTotal property (Word) True if the point represents a total. Read/write Boolean.
Series.ParentDataLabelOption property (Word) Specifies the parent data label option (banner, overlapping, or none) for the specified series within the chart group. Read/write XlParentDataLabelOptions.
Series.QuartileCalculationInclusiveMedian property (Word) True if the series uses an inclusive median quartile calculation method. Read/write Boolean.
XlBinsType enumeration (Word) Constants passed to and returned by the ChartGroup.BinsType property.
XlParentDataLabelOptions enumeration (Word) Constants passed to and returned by the Series.ParentDataLabelOption property.

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.