wxAutoExcel
2.0.0
|
All wxAutoExcel classes and enumerations are declared in wxAutoExcel namespace. More...
Classes | |
class | wxExcelException |
The exception that is thrown if there's an error and wxExcelObject::GetErrorMode()_ has at least one of the Err_ThrowOn* flags set. More... | |
class | wxExcelObject |
The base object for all wxAutoExcel objects. More... | |
class | wxAutoExcelObjectErrorModeOverrider |
Sets the new error reporting mode for wxAutoExcel, restores the previous error mode when going out of scope. More... | |
class | wxXlTribool |
Tri-state boolean. More... | |
class | wxExcelAboveAverage |
Represents a Microsoft Excel AboveAverage object. More... | |
class | wxExcelAddIn |
Represents a single add-in, either installed or not installed. More... | |
class | wxExcelAddInsBase |
This class cannot be instantiated, it has to be used either as wxExcelAddIns or wxExcelAddIns2. More... | |
class | wxExcelAddIns |
A collection of AddIn objects that represents all the add-ins available to Microsoft Excel, regardless of whether they’re installed. More... | |
class | wxExcelAddIns2 |
A collection of AddIn objects that represent all the add-ins that are currently available or open in Microsoft Excel, regardless of whether they are installed. More... | |
class | wxExcelAdjustments |
Represents Microsoft Excel Adjustments object. More... | |
class | wxExcelAllowEditRange |
Represents a collection of all the AllowEditRange objects that represent the cells that can be edited on a protected worksheet. More... | |
class | wxExcelAllowEditRanges |
Represents a collection of all the AllowEditRange objects that represent the cells that can be edited on a protected worksheet. More... | |
class | wxExcelApplication |
Represents Microsoft Excel Application. More... | |
class | wxExcelAreas |
Represents Microsoft Excel Areas collection. More... | |
class | wxExcelAuthor |
Represents the author of the CommentThreaded object. More... | |
class | wxExcelAutoFilter |
Represents Microsoft Excel AutoFilter object. More... | |
class | wxExcelAxis |
Represents Microsoft Excel Axis object. More... | |
class | wxExcelAxes |
Represents Microsoft Excel Axes collection. More... | |
class | wxExcelAxisTitle |
Represents Microsoft Excel AxisTitle object. More... | |
class | wxExcelBorder |
Represents Microsoft Excel Border object. More... | |
class | wxExcelBorders |
Represents Microsoft Excel Borders collection. More... | |
class | wxExcelBulletFormat2 |
Represents Microsoft Excel BulletFormat2 object. More... | |
class | wxExcelCalloutFormat |
Represents Microsoft Excel CalloutFormat object. More... | |
class | wxExcelCharacters |
Represents Microsoft Excel Characters. More... | |
class | wxExcelChart |
Represents Microsoft Excel Chart object. More... | |
class | wxExcelChartArea |
Represents Microsoft Excel ChartArea object. More... | |
class | wxExcelChartCategory |
Specifies a chart type category. More... | |
class | wxExcelCategoryCollection |
Represents the collection of visible chart categories in the chart. More... | |
class | wxExcelChartColorFormat |
Represents Microsoft Excel ChartColorFormat object. More... | |
class | wxExcelChartFillFormat |
Represents Microsoft Excel ChartFillFormat object. More... | |
class | wxExcelChartFormat |
Represents Microsoft Excel ChartFormat object. More... | |
class | wxExcelChartGroup |
Represents Microsoft Excel ChartGroup object. More... | |
class | wxExcelChartGroups |
Represents Microsoft Excel ChartGroups collection. More... | |
class | wxExcelChartObject |
Represents Microsoft Excel ChartObject object. More... | |
class | wxExcelChartObjects |
Represents Microsoft Excel ChartObjects collection. More... | |
class | wxExcelCharts |
Represents Microsoft Excel Charts collection. More... | |
class | wxExcelChartTitle |
Represents Microsoft Excel ChartTitle object. More... | |
class | wxExcelChartView |
Represents Microsoft Excel ChartView object. More... | |
class | wxExcelColorFormat |
Represents Microsoft Excel ColorFormat object. More... | |
class | wxExcelColorScale |
Represents a Microsoft Excel ColorScale object. More... | |
class | wxExcelColorScaleCriterion |
Represents a Microsoft Excel ColorScaleCriterion object. More... | |
class | wxExcelColorScaleCriteria |
Represents a Microsoft Excel ColorScaleCriteria collection. More... | |
class | wxExcelComment |
Represents Microsoft Excel Comment object. More... | |
class | wxExcelComments |
Represents Microsoft Excel Comments collection. More... | |
class | wxExcelCommentThreaded |
Represents a cell's threaded comment. More... | |
class | wxExcelCommentsThreaded |
Represents a collection of CustomProperty objects that represent additional information. More... | |
class | wxExcelConditionValue |
Represents a Microsoft Excel ConditionValue object. More... | |
class | wxExcelConnectorFormat |
Represents Microsoft Excel ConnectorFormat object. More... | |
class | wxExcelControlFormat |
Represents Microsoft Excel ControlFormat object. More... | |
class | wxExcelCustomProperty |
Represents identifier information. More... | |
class | wxExcelCustomProperties |
Represents a collection of CustomProperty objects that represent additional information. More... | |
class | wxExcelDatabar |
Represents a Microsoft Excel Databar object. More... | |
class | wxExcelDataBarBorder |
Represents the border of the data bars specified by a conditional formatting rule. More... | |
class | wxExcelDataLabel |
Represents Microsoft Excel DataLabel object. More... | |
class | wxExcelDataLabels |
Represents Microsoft Excel DataLabels collection. More... | |
class | wxExcelDataTable |
Represents Microsoft Excel DataTable object. More... | |
class | wxExcelDisplayFormat |
Represents the display settings for an associated Range object. More... | |
class | wxExcelDisplayUnitLabel |
Represents Microsoft Excel DisplayUnitLabel object. More... | |
class | wxExcelDocumentProperty |
Represents a Microsoft Excel DocumentProperty object. More... | |
class | wxExcelDocumentProperties |
Represents a Microsoft Excel (Office) DocumentProperties collection. More... | |
class | wxExcelDownBars |
Represents Microsoft Excel DownBars object. More... | |
class | wxExcelDropLines |
Represents Microsoft Excel DropLines object. More... | |
class | wxExcelErrorBars |
Represents Microsoft Excel ErrorBars object. More... | |
class | wxExcelErrorCheckingOptions |
Represents Microsoft Excel ErrorCheckingOptions object. More... | |
class | wxExcelError |
Represents Microsoft Excel Error object. More... | |
class | wxExcelErrors |
Represents Microsoft Excel Errors collection. More... | |
class | wxExcelFileExportConverter |
Represents a file converter that is used to save files. More... | |
class | wxExcelFileExportConverters |
Represents a collection of FileExportConverter objects that represent all the file converters available for saving files. More... | |
class | wxExcelFillFormat |
Represents Microsoft Excel FillFormat object. More... | |
class | wxExcelFilter |
Represents Microsoft Excel Filter object. More... | |
class | wxExcelFilters |
Represents Microsoft Excel Filters collection. More... | |
class | wxExcelFloor |
Represents Microsoft Excel Floor object. More... | |
class | wxExcelFont |
Represents Microsoft Excel Font. More... | |
class | wxExcelFont2 |
Represents Microsoft Excel Font2 object. More... | |
class | wxExcelFormatColor |
Represents a Microsoft Excel FormatColor object. More... | |
class | wxExcelFormatCondition |
Represents Microsoft Excel FormatCondition object. More... | |
class | wxExcelFormatConditions |
Represents Microsoft Excel FormatConditions collection. More... | |
class | wxExcelFreeformBuilder |
Represents Microsoft Excel FreeformBuilder object. More... | |
class | wxExcelGlowFormat |
Represents Microsoft Excel GlowFormat object. More... | |
class | wxExcelColorStop |
Represents Microsoft Excel ColorStop object. More... | |
class | wxExcelColorStops |
Represents Microsoft Excel ColorStops collection. More... | |
class | wxExcelLinearGradient |
Represents Microsoft Excel LinearGradient object. More... | |
class | wxExcelRectangularGradient |
Represents Microsoft Excel RectangularGradient object. More... | |
class | wxExcelGraphic |
Represents Microsoft Excel Graphic object. More... | |
class | wxExcelGridlines |
Represents Microsoft Excel Gridlines object. More... | |
class | wxExcelGroupShapes |
Represents Microsoft Excel GroupShapes collection. More... | |
class | wxExcelHeaderFooter |
Represents Microsoft Excel HeaderFooter. More... | |
class | wxExcelHiLoLines |
Represents Microsoft Excel HiLoLines object. More... | |
class | wxExcelHyperlink |
Represents Microsoft Excel Hyperlink object. More... | |
class | wxExcelHyperlinks |
Represents Microsoft Excel Hyperlinks collection. More... | |
class | wxExcelIcon |
Represents Microsoft Excel Icon object. More... | |
class | wxExcelIconCriterion |
Represents a Microsoft Excel IconCriterion object. More... | |
class | wxExcelIconCriteria |
Represents a Microsoft Excel IconCriteria collection. More... | |
class | wxExcelIconSetCondition |
Represents a Microsoft Excel IconSetCondition object. More... | |
class | wxExcelIconSet |
Represents a Microsoft Excel IconSet object. More... | |
class | wxExcelIconSets |
Represents a Microsoft Excel IconSets collection. More... | |
class | wxExcelInterior |
Represents Microsoft Excel Interior. More... | |
class | wxExcelLanguageSettings |
Represents Microsoft Excel LanguageSettings object. More... | |
class | wxExcelLeaderLines |
Represents Microsoft Excel LeaderLines object. More... | |
class | wxExcelLegend |
Represents Microsoft Excel Legend object. More... | |
class | wxExcelLegendEntry |
Represents Microsoft Excel LegendEntry object. More... | |
class | wxExcelLegendEntries |
Represents Microsoft Excel LegendEntries collection. More... | |
class | wxExcelLegendKey |
Represents Microsoft Excel LegendKey object. More... | |
class | wxExcelLineFormat |
Represents Microsoft Excel LineFormat object. More... | |
class | wxExcelLinkFormat |
Represents Microsoft Excel LinkFormat object. More... | |
class | wxExcelListColumn |
Represents a column in a table, a member of ListColumns collection. More... | |
class | wxExcelListColumns |
Represents a collection of ListColumn objects. More... | |
class | wxExcelListDataFormat |
Represents an object holding all data type properties for ListColumn. More... | |
class | wxExcelListObject |
Represents a list object in ListObjects collection. More... | |
class | wxExcelListObjects |
Represents a collection of ListObject objects on a worksheet, where each ListObject object represents a table on the worksheet. More... | |
class | wxExcelListRow |
Represents a row in table, a member of ListRows collection. More... | |
class | wxExcelListRows |
Represents a collection of ListRow objects. More... | |
class | wxExcelModel3DFormat |
Represents the properties of a 3D model shape. More... | |
class | wxExcelMultiThreadedCalculation |
Represents an object that returns or sets the concurrent calculation mode. More... | |
class | wxExcelName |
Represents Microsoft Excel Name object. More... | |
class | wxExcelNames |
Represents Microsoft Excel Names collection. More... | |
class | wxExcelNegativeBarFormat |
Represents a Microsoft Excel NegativeBarFormat object. More... | |
class | wxExcelOLEFormat |
Represents Microsoft Excel OLEFormat object. More... | |
class | wxExcelOLEObject |
Represents Microsoft Excel OLEObject object. More... | |
class | wxExcelOLEObjects |
Represents Microsoft Excel OLEObjects collection. More... | |
class | wxExcelOutline |
Represents an outline on a worksheet. More... | |
class | wxExcelPageBreak |
Represents Microsoft Excel HPageBreak or VPageBreak object. More... | |
class | wxExcelPageBreaks |
Represents Microsoft Excel HPageBreaks or VPageBreaks collection. More... | |
class | wxExcelPage |
Represents Microsoft Excel Page object. More... | |
class | wxExcelPages |
Represents Microsoft Excel Pages collection. More... | |
class | wxExcelPageSetup |
Represents Microsoft Excel PageSetup object. More... | |
class | wxExcelPane |
Represents Microsoft Excel Pane object. More... | |
class | wxExcelPanes |
Represents Microsoft Excel Panes collection. More... | |
class | wxExcelParagraphFormat2 |
Represents Microsoft Excel ParagraphFormat2 object. More... | |
class | wxExcelPictureFormat |
Represents Microsoft Excel PictureFormat object. More... | |
class | wxExcelPlotArea |
Represents Microsoft Excel PlotArea object. More... | |
class | wxExcelPoint |
Represents Microsoft Excel Point object. More... | |
class | wxExcelPoints |
Represents Microsoft Excel Points collection. More... | |
class | wxExcelProtection |
Represents the various types of protection options available for a worksheet. More... | |
class | wxExcelRange |
Represents Microsoft Excel Range, i.e. More... | |
class | wxExcelRangeOwner |
Helper object that contains methods common to objects that can return Ranges. More... | |
class | wxExcelRecentFile |
Represents a Microsoft Excel RecentFile object. More... | |
class | wxExcelRecentFiles |
Represents a Microsoft Excel (Office) RecentFiles collection. More... | |
class | wxExcelReflectionFormat |
Represents Microsoft Excel ReflectionFormat object. More... | |
class | wxExcelSeries |
Represents Microsoft Excel Series object. More... | |
class | wxExcelSeriesCollection |
Represents Microsoft Excel SeriesCollection collection. More... | |
class | wxExcelFullSeriesCollection |
Represents the full set of Series objects in the chart. More... | |
class | wxExcelSeriesLines |
Represents Microsoft Excel SeriesLines object. More... | |
class | wxExcelShadowFormat |
Represents Microsoft Excel ShadowFormat object. More... | |
class | wxExcelShape |
Represents Microsoft Excel Shape object. More... | |
class | wxExcelShapeNode |
Represents Microsoft Excel ShapeNode object. More... | |
class | wxExcelShapeNodes |
Represents Microsoft Excel ShapeNodes collection. More... | |
class | wxExcelShapeRange |
Represents Microsoft Excel ShapeRange object. More... | |
class | wxExcelShapes |
Represents Microsoft Excel Shape object. More... | |
class | wxExcelSheet |
Represents a member of Microsoft Excel Sheets collection. More... | |
class | wxExcelSheets |
Represents Microsoft Excel Sheets collection. More... | |
class | wxExcelSheetView |
Represents Microsoft Excel SheetView object. More... | |
class | wxExcelSheetViews |
Represents Microsoft Excel SheetViews collection. More... | |
class | wxExcelSoftEdgeFormat |
Represents Microsoft Excel SoftEdgeFormat object. More... | |
class | wxExcelSort |
Represents Microsoft Excel Sort object. More... | |
class | wxExcelSortField |
Represents Microsoft Excel SortFields object. More... | |
class | wxExcelSortFields |
Represents Microsoft Excel SortFields collection. More... | |
class | wxExcelSparkHorizontalAxis |
Represents Microsoft Excel SparkHorizontalAxis object. More... | |
class | wxExcelSparkVerticalAxis |
Represents Microsoft Excel SparkVerticalAxis object. More... | |
class | wxExcelSparkAxes |
Represents Microsoft Excel SparkAxes object. More... | |
class | wxExcelSparkColor |
Represents Microsoft Excel SparkColor object. More... | |
class | wxExcelSparkline |
Represents Microsoft Excel Sparkline object. More... | |
class | wxExcelSparklineGroup |
Represents Microsoft Excel SparklineGroup object. More... | |
class | wxExcelSparklineGroups |
Represents Microsoft Excel SparklineGroups collection. More... | |
class | wxExcelSparkPoints |
Represents Microsoft Excel SparkPoints object. More... | |
class | wxExcelStyle |
Represents Microsoft Excel Style object. More... | |
class | wxExcelStyles |
Represents Microsoft Excel Styles collection. More... | |
class | wxExcelTab |
Represents Microsoft Excel Sheet Tab. More... | |
class | wxExcelTableObject |
Represents a worksheet table built from data returned from a PowerPivot model. More... | |
class | wxExcelTableStyle |
Represents a single style that can be applied to a table or slicer. More... | |
class | wxExcelTableStyles |
Represents styles that can be applied to a table. More... | |
class | wxExcelTableStyleElement |
Represents a table style element. More... | |
class | wxExcelTableStyleElements |
Represents a collection of TableStyleElement objects. More... | |
class | wxExcelTabStop2 |
Represents Microsoft Excel TabStop2 object. More... | |
class | wxExcelTabStops2 |
Represents Microsoft Excel TabStops2 collection. More... | |
class | wxExcelTextColumn2 |
Represents Microsoft Excel TextColumn2 object. More... | |
class | wxExcelTextEffectFormat |
Represents Microsoft Excel TextEffectFormat object. More... | |
class | wxExcelTextFrame |
Represents Microsoft Excel TextFrame. More... | |
class | wxExcelTextFrame2 |
Represents Microsoft Excel TextFrame2. More... | |
class | wxExcelTextRange2 |
Represents Microsoft Excel TextRange2 object. More... | |
class | wxExcelThreeDFormat |
Represents Microsoft Excel ThreeDFormat object. More... | |
class | wxExcelTickLabels |
Represents Microsoft Excel TickLabels object. More... | |
class | wxExcelTop10 |
Represents a Microsoft Excel Top10 object. More... | |
class | wxExcelTrendline |
Represents Microsoft Excel Trendline object. More... | |
class | wxExcelTrendlines |
Represents Microsoft Excel Trendlines collection. More... | |
class | wxExcelUniqueValues |
Represents a Microsoft Excel UniqueValues object. More... | |
class | wxExcelUpBars |
Represents Microsoft Excel UpBars object. More... | |
class | wxExcelUserAccess |
Represents Represents the user access for a protected range. More... | |
class | wxExcelUserAccessList |
Represents a collection of all the UserAccess objects that represent the cells that can be edited on a protected worksheet. More... | |
class | wxExcelValidation |
Represents Microsoft Excel Validation object. More... | |
class | wxExcelWalls |
Represents Microsoft Excel Walls object. More... | |
class | wxExcelWindow |
Represents Microsoft Excel Window object. More... | |
class | wxExcelWindows |
Represents Microsoft Excel Window Pane collection. More... | |
class | wxExcelWorkbook |
Represents Microsoft Excel Workbook. More... | |
class | wxExcelWorkbooks |
Represents Microsoft Excel Workbooks collection. More... | |
class | wxExcelWorksheet |
Represents Microsoft Excel Worksheet. More... | |
class | wxExcelWorksheets |
Represents Microsoft Excel Worksheets collection. More... | |
class | wxExcelWorksheetView |
Represents Microsoft Excel WorksheetView. More... | |
Typedefs | |
typedef wxVector< wxVariant > | wxVariantVector |
wxVector of wxVariants. More... | |
Functions | |
WXDLLIMPEXP_DATA_WXAUTOEXCEL (wxXlTribool) wxDefaultXlTribool | |
XlTribool instance with default state. More... | |
All wxAutoExcel classes and enumerations are declared in wxAutoExcel namespace.
typedef wxVector<wxVariant> wxAutoExcel::wxVariantVector |
wxVector of wxVariants.
This enumeration groups together constants used with various Excel methods.
Official VBA documentation for Constants
Specifies if the values are above or below average.
Official VBA documentation for XlAboveBelow
Specifies the action that should be performed.
Official VBA documentation for XlActionType
Enumerator | |
---|---|
xlActionTypeDrillthrough | Drill through |
xlActionTypeReport | Report |
xlActionTypeRowset | Rowset |
xlActionTypeUrl | URL |
Specifies when to calculate changes when performing what-if analysis on a PivotTable based on an OLAP data source.
Official VBA documentation for XlAllocation
Enumerator | |
---|---|
xlAutomaticAllocation | Calculate changes automatically after each value is changed. |
xlManualAllocation | Calculate changes manually. |
Specifies the method to use to allocate values when performing what-if analysis on a PivotTable report based on an OLAP data source.
Official VBA documentation for XlAllocationMethod
Enumerator | |
---|---|
xlEqualAllocation | Use equal allocation. |
xlWeightedAllocation | Use weighted allocation. |
Specifies what value to allocate when performing what-if analysis on a PivotTable report based on an OLAP data source.
Official VBA documentation for XlAllocationValue
Enumerator | |
---|---|
xlAllocateIncrement | Increment based on the old value. |
xlAllocateValue | The value entered divided by the number of allocations. |
Specifies country/region and international settings.
Official VBA documentation for XlApplicationInternational
Specifies which range name is listed first when a cell reference is replaced by a row-oriented and column-oriented range name.
Official VBA documentation for XlApplyNamesOrder
Enumerator | |
---|---|
xlColumnThenRow | Columns listed before rows |
xlRowThenColumn | Rows listed before columns |
Specifies spelling rules for the Arabic spelling checker.
Official VBA documentation for XlArabicModes
Specifies how windows are arranged on the screen.
Official VBA documentation for XlArrangeStyle
Specifies the length of the arrowhead at the end of a line.
Official VBA documentation for XlArrowHeadLength
Enumerator | |
---|---|
xlArrowHeadLengthLong | Longest arrowhead |
xlArrowHeadLengthMedium | Medium-length arrowhead |
xlArrowHeadLengthShort | Shortest arrowhead |
Specifies the type of arrowhead to apply at the end of a line.
Official VBA documentation for XlArrowHeadStyle
Specifies the width of the arrowhead at the end of a line.
Official VBA documentation for XlArrowHeadWidth
Enumerator | |
---|---|
xlArrowHeadWidthMedium | Medium-width arrowhead |
xlArrowHeadWidthNarrow | Narrowest arrowhead |
xlArrowHeadWidthWide | Widest arrowhead |
Specifies how the target range is to be filled, based on the contents of the source range.
Official VBA documentation for XlAutoFillType
Specifies the operator to use to associate two criteria applied by a filter.
Official VBA documentation for XlAutoFilterOperator
Specifies the point on the specified axis where the other axis crosses.
Official VBA documentation for XlAxisCrosses
Specifies the type of axis group.
Official VBA documentation for XlAxisGroup
Enumerator | |
---|---|
xlPrimary | Primary axis group |
xlSecondary | Secondary axis group |
Specifies the axis type.
Official VBA documentation for XlAxisType
Enumerator | |
---|---|
xlCategory | Axis displays categories. |
xlSeriesAxis | Axis displays data series. |
xlValue | Axis displays values. |
Specifies the background type for text in charts.
Official VBA documentation for XlBackground
Enumerator | |
---|---|
xlBackgroundAutomatic | Excel controls the background. |
xlBackgroundOpaque | Opaque background. |
xlBackgroundTransparent | Transparent background. |
Specifies the shape used with the 3D bar or column chart.
Official VBA documentation for XlBarShape
Constants passed to and returned by the ChartGroup.BinsType property.
Official VBA documentation for XlBinsType
Specifies the weight of the border around a range.
Official VBA documentation for XlBorderWeight
Enumerator | |
---|---|
xlHairline | Hairline (thinnest border). |
xlMedium | Medium. |
xlThick | Thick (widest border). |
xlThin | Thin. |
Specifies the border to be retrieved.
Official VBA documentation for XlBordersIndex
Specifies which dialog box to display.
Official VBA documentation for XlBuiltInDialog
Specifies the cell error number and value.
Official VBA documentation for XlCVError
Specifies what should be calculated.
Official VBA documentation for XlCalcFor
Enumerator | |
---|---|
xlAllValues | All values. |
xlColGroups | Column groups. |
xlRowGroups | Row groups. |
Specifies the format of cell values that are based on the calculated member.
Official VBA documentation for XlCalcMemNumberFormatType
Specifies the type of a calculated member in a PivotTable.
Official VBA documentation for XlCalculatedMemberType
Specifies the calculation mode.
Official VBA documentation for XlCalculation
Specifies which key interrupts recalculation.
Official VBA documentation for XlCalculationInterruptKey
Enumerator | |
---|---|
xlAnyKey | Pressing any key interrupts recalculation. |
xlEscKey | Pressing the ESC key interrupts recalculation. |
xlNoKey | No key press can interrupt recalculation. |
Specifies the calculation state of the application.
Official VBA documentation for XlCalculationState
Enumerator | |
---|---|
xlCalculating | Calculations in process. |
xlDone | Calculations complete. |
xlPending | Changes that trigger calculation have been made, but a recalculation has not yet been performed. |
Specifies the category labels for the category label levels.
Official VBA documentation for XlCategoryLabelLevel
Specifies the type of the category axis.
Official VBA documentation for XlCategoryType
Enumerator | |
---|---|
xlAutomaticScale | Excel controls the axis type. |
xlCategoryScale | Axis groups data by an arbitrary set of categories. |
xlTimeScale | Axis groups data on a time scale. |
Specifies whether a PivotTable value cell has been edited or recalculated since the PivotTable report was created or the last commit operation was performed.
Official VBA documentation for XlCellChangedState
Specifies the way that rows on the specified worksheet are added or deleted to accommodate the number of rows in a recordset returned by a query.
Official VBA documentation for XlCellInsertionMode
Specifies the type of cells.
Official VBA documentation for XlCellType
Specifies the position of the chart element.
Official VBA documentation for XlChartElementPosition
Enumerator | |
---|---|
xlChartElementPositionAutomatic | Automatically sets the position of the chart element. |
xlChartElementPositionCustom | Specifies a specific position for the chart element. |
Specifies a chart gallery.
Official VBA documentation for XlChartGallery
Enumerator | |
---|---|
xlAnyGallery | Either of the galleries. |
xlBuiltIn | The built-in gallery. |
xlUserDefined | The user-defined gallery. |
Specifies the type of the chart item.
Official VBA documentation for XlChartItem
Specifies where to relocate a chart.
Official VBA documentation for XlChartLocation
Enumerator | |
---|---|
xlLocationAsNewSheet | Chart is moved to a new sheet. |
xlLocationAsObject | Chart is to be embedded in an existing sheet. |
xlLocationAutomatic | Excel controls chart location. |
Specifies the placement of a user-selected picture on a bar in a 3D bar or column.
Official VBA documentation for XlChartPicturePlacement
Specifies how pictures are displayed on a column, bar picture chart, or legend key.
Official VBA documentation for XlChartPictureType
Specifies the values displayed in the second chart in a pie chart or a Bar of Pie chart.
Official VBA documentation for XlChartSplitType
Specifies the chart type.
Official VBA documentation for XlChartType
Specifies the type of version for the document checked in when using the CheckIn method.
Applies to workbooks stored in a SharePoint library.
Official VBA documentation for XlCheckInVersionType
Enumerator | |
---|---|
xlCheckInMajorVersion | Check in the major version. |
xlCheckInMinorVersion | Check in the minor version. |
xlCheckInOverwriteVersion | Overwrite current version on the server. |
Specifies the format of an item on the Microsoft Windows clipboard.
Official VBA documentation for XlClipboardFormat
Specifies the value of the CommandText property.
Official VBA documentation for XlCmdType
Specifies the color of a selected feature, such as a border, font, or fill.
Official VBA documentation for XlColorIndex
Enumerator | |
---|---|
xlColorIndexAutomatic | Automatic color. |
xlColorIndexNone | No color. |
Specifies how a column is to be parsed.
Official VBA documentation for XlColumnDataType
Specifies the state of the command underlines in Microsoft Excel for the Macintosh.
Official VBA documentation for XlCommandUnderlines
Specifies the way that cells display comments and comment indicators.
Official VBA documentation for XlCommentDisplayMode
Specifies the types of condition values that can be used.
Official VBA documentation for XlConditionValueTypes
Specifies the type of database connection.
Official VBA documentation for XlConnectionType
Specifies the subtotal function.
Official VBA documentation for XlConsolidationFunction
Specifies the operator used in a function.
Official VBA documentation for XlContainsOperator
Enumerator | |
---|---|
xlBeginsWith | Begins with a specified value. |
xlContains | Contains a specified value. |
xlDoesNotContain | Does not contain the specified value. |
xlEndsWith | Endswith the specified value |
Specifies the format of the picture being copied.
Official VBA documentation for XlCopyPictureFormat
Enumerator | |
---|---|
xlBitmap | Picture copied in bitmap (raster) format: bmp, jpg, gif, png. |
xlPicture | Picture copied in vector format: emf, wmf. |
Specifies the processing for a file when it is opened.
Official VBA documentation for XlCorruptLoad
Enumerator | |
---|---|
xlExtractData | Workbook is opened in extract data mode. |
xlNormalLoad | Workbook is opened normally. |
xlRepairFile | Workbook is opened in repair mode. |
Specifies the 32-bit creator code for Excel for Macintosh (decimal 1480803660, Hex 5843454C, string XCEL).
Official VBA documentation for XlCreator
Enumerator | |
---|---|
xlCreatorCode | The Excel for Macintosh creator code. |
Specifies the type of credentials method used.
Official VBA documentation for XlCredentialsMethod
Enumerator | |
---|---|
CredentialsMethodIntegrated | Integrated |
CredentialsMethodNone | No credentials used |
CredentialsMethodStored | Use stored credentials |
Specifies the subtype of the CubeField.
Official VBA documentation for XlCubeFieldSubType
Specifies whether the OLAP field is a hierarchy, set, or measure field.
Official VBA documentation for XlCubeFieldType
Enumerator | |
---|---|
xlHierarchy | OLAP field is a hierarchy. |
xlMeasure | OLAP field is a measure. |
xlSet | OLAP field is a set. |
Specifies whether status is Copy mode or Cut mode.
Official VBA documentation for XlCutCopyMode
Enumerator | |
---|---|
xlCopy | In Copy mode |
xlCut | In Cut mode |
Specifies the icon used in message boxes displayed during validation.
Official VBA documentation for XlDVAlertStyle
Enumerator | |
---|---|
xlValidAlertInformation | Information icon. |
xlValidAlertStop | Stop icon. |
xlValidAlertWarning | Warning icon. |
Specifies the type of validation test to be performed in conjunction with values.
Official VBA documentation for XlDVType
Specifies the axis position for a range of cells with conditional formatting as data bars.
Official VBA documentation for XlDataBarAxisPosition
Specifies the border of a data bar.
Official VBA documentation for XlDataBarBorderType
Enumerator | |
---|---|
xlDataBarBorderNone | The data bar has no border. |
xlDataBarBorderSolid | The data bar has a solid border. |
Specifies how a data bar is filled with color.
Official VBA documentation for XlDataBarFillType
Enumerator | |
---|---|
xlDataBarFillGradient | The data bar is filled with a color gradient. |
xlDataBarFillSolid | The data bar is filled with solid color. |
Specifies whether to use the same border and fill color as positive data bars.
Official VBA documentation for XlDataBarNegativeColorType
Specifies where the data label is positioned.
Official VBA documentation for XlDataLabelPosition
Specifies the separator used with data labels.
Official VBA documentation for XlDataLabelSeparator
Enumerator | |
---|---|
xlDataLabelSeparatorDefault | Excel selects the separator. |
Specifies the type of data label to apply.
Official VBA documentation for XlDataLabelsType
Specifies the type of date to apply to a data series.
Official VBA documentation for XlDataSeriesDate
Enumerator | |
---|---|
xlDay | Day |
xlMonth | Month |
xlWeekday | Weekdays |
xlYear | Year |
Specifies the data series to create.
Official VBA documentation for XlDataSeriesType
Specifies how to shift cells to replace deleted cells.
Official VBA documentation for XlDeleteShiftDirection
Enumerator | |
---|---|
xlShiftToLeft | Cells are shifted to the left. |
xlShiftUp | Cells are shifted up. |
Specifies the direction in which to move.
Official VBA documentation for XlDirection
Enumerator | |
---|---|
xlDown | Down. |
xlToLeft | To left. |
xlToRight | To right. |
xlUp | Up. |
Specifies how blank cells are plotted on a chart.
Official VBA documentation for XlDisplayBlanksAs
Enumerator | |
---|---|
xlInterpolated | Values are interpolated into the chart. |
xlNotPlotted | Blank cells are not plotted. |
xlZero | Blanks are plotted as zero. |
Specifies how shapes are displayed.
Official VBA documentation for XlDisplayDrawingObjects
Enumerator | |
---|---|
xlDisplayShapes | Show all shapes. |
xlHide | Hide all shapes. |
xlPlaceholders | Show only placeholders. |
Specifies the display unit label for an axis.
Official VBA documentation for XlDisplayUnit
Specifies whether duplicate or unique values shoud be displayed.
Official VBA documentation for XlDupeUnique
Enumerator | |
---|---|
xlDuplicate | Display duplicate values. |
xlUnique | Display unique values. |
Specifies the filter criterion.
Official VBA documentation for XlDynamicFilterCriteria
Specifies the format of the published edition.
This enumeration is only for Macintosh and should not be used.
Official VBA documentation for XlEditionFormat
Enumerator | |
---|---|
xlBIFF | Binary Interchange file format. |
xlPICT | Metafile picture structure (.wmf). |
xlRTF | Rich Text Format (.rtf). |
xlVALU | VALU. |
This enumeration is only for Macintosh and should not be used.
Official VBA documentation for XlEditionOptionsOption
Specifies the type of edition to be changed.
Official VBA documentation for XlEditionType
Enumerator | |
---|---|
xlPublisher | Publisher |
xlSubscriber | Subscriber |
Specifies how Microsoft Office Excel 2007 handles CTRL+BREAK (or ESC or COMMAND+PERIOD) user interruptions to the running procedure.
Official VBA documentation for XlEnableCancelKey
Specifies what can be selected on the sheet.
Official VBA documentation for XlEnableSelection
Enumerator | |
---|---|
xlNoRestrictions | Anything can be selected. |
xlNoSelection | Nothing can be selected. |
xlUnlockedCells | Only unlocked cells can be selected. |
Specifies the end style for error bars.
Official VBA documentation for XlEndStyleCap
Enumerator | |
---|---|
xlCap | Caps applied. |
xlNoCap | No caps applied. |
Specifies which axis values are to receive error bars.
Official VBA documentation for XlErrorBarDirection
Enumerator | |
---|---|
xlX | Bars run parallel to the Y axis for X-axis values. |
xlY | Bars run parallel to the X axis for Y-axis values. |
Specifies which error-bar parts to include.
Official VBA documentation for XlErrorBarInclude
Specifies the range marked by error bars.
Official VBA documentation for XlErrorBarType
Specifies the type of error object to be retrieved from the Errors collection.
Official VBA documentation for XlErrorChecks
Specifies the new access mode for the object.
Official VBA documentation for XlFileAccess
Enumerator | |
---|---|
xlReadOnly | Read-only |
xlReadWrite | Read/write |
Specifies the file format when saving the worksheet.
Official VBA documentation for XlFileFormat
Specifies how to validate the data caches for PivotTable reports.
Official VBA documentation for XlFileValidationPivotMode
Specifies how to copy the range.
Official VBA documentation for XlFillWith
Enumerator | |
---|---|
xlFillWithAll | Copy contents and formats. |
xlFillWithContents | Copy contents only. |
xlFillWithFormats | Copy formats only. |
Specifies whether data is to be copied or left in place during a filter operation.
Official VBA documentation for XlFilterAction
Enumerator | |
---|---|
xlFilterCopy | Copy filtered data to new location. |
xlFilterInPlace | Leave data in place. |
Specifies how dates should be filtered in the specified period.
Official VBA documentation for XlFilterAllDatesInPeriod
Used to return a status from filter functions.
Official VBA documentation for XlFilterStatus
Specifies the type of data to search.
Official VBA documentation for XlFindLookIn
Enumerator | |
---|---|
xlComments | Comments |
xlCommentsThreaded | Threaded comments |
xlFormulas | Formulas |
xlValues | Values |
Specifies the quality of spreadsheets saved in different fixed formats.
Official VBA documentation for XlFixedFormatQuality
Enumerator | |
---|---|
xlQualityMinimum | Minimum quality |
xlQualityStandard | Standard quality |
Specifies the type of file format.
Official VBA documentation for XlFixedFormatType
Enumerator | |
---|---|
xlTypePDF | "PDF" - Portable Document Format file (.pdf) |
xlTypeXPS | "XPS" - XPS Document (.xps) |
Constants passed to various WorksheetFunction and Workbook statistical forecasting methods.
Official VBA documentation for XlForecastAggregation
Constants passed to the Workbook.CreateForecastSheet Method.
Official VBA documentation for XlForecastChartType
Enumerator | |
---|---|
xlForecastChartTypeColumnxlForecastChartTypeLine | Column chartLine chart |
Constants passed to various WorksheetFunction and Workbook statistical forecasting methods.
Official VBA documentation for XlForecastDataCompletion
Enumerator | |
---|---|
xlForecastDataCompletionInterpolatexlForecastDataCompletionZeros | Data completion by interpolationData completion by zeroes |
Specifies the type of the form control.
Official VBA documentation for XlFormControl
Specifies the operator to use to compare a formula against the value in a cell or, for xlBetween and xlNotBetween, to compare two formulas.
Official VBA documentation for XlFormatConditionOperator
Specifies whether the conditional format is based on a cell value or an expression.
Official VBA documentation for XlFormatConditionType
Specifies the types of format filters.
Official VBA documentation for XlFormatFilterTypes
Enumerator | |
---|---|
FilterBottom | Bottom. |
FilterBottomPercent | Bottom Percent. |
FilterTop | Top. |
FilterTopPercent | Top Percent. |
Specifies the formula label type for the specified range.
Official VBA documentation for XlFormulaLabel
Enumerator | |
---|---|
xlColumnLabels | Column labels only. |
xlMixedLabels | Row and column labels. |
xlNoLabels | No labels. |
xlRowLabels | Row labels only. |
Specifies the type of table references.
Official VBA documentation for XlGenerateTableRefs
Enumerator | |
---|---|
xlA1TableRefs | A1 Table References. |
xlTableNames | Table Names. |
Constants passed to and returned by the Series.GeoMappingLevel property.
Official VBA documentation for XlGeoMappingLevel
Constants passed to and returned by the Series.GeoProjectionType property.
Official VBA documentation for XlGeoProjectionType
Specifies the type of gradient fill.
Official VBA documentation for XlGradientFillType
Enumerator | |
---|---|
GradientFillLinear | Gradient is filled in a straight line. |
GradientFillPath | Gradient is filled in a non-linear or curved path. |
Specifies the horizontal alignment for the object.
Official VBA documentation for XlHAlign
Specifies the mode for the Hebrew spelling checker.
Official VBA documentation for XlHebrewModes
Specifies which set of changes is shown in a shared workbook.
Official VBA documentation for XlHighlightChangesTime
Enumerator | |
---|---|
xlAllChanges | Show all changes. |
xlNotYetReviewed | Show only changes not yet reviewed. |
xlSinceMyLastSave | Show changes made since last save by last user. |
Specifies the description of the Japanese input rules.
Official VBA documentation for XlIMEMode
enum wxAutoExcel::XlIcon |
Specifies the icon for a criterion in an icon set conditional formatting rule.
Official VBA documentation for XlIcon
Specifies the type of icon set.
Official VBA documentation for XlIconSet
Specifies the format in which to return data from a database.
Official VBA documentation for XlImportDataAs
Enumerator | |
---|---|
xlPivotTableReport | Returns the data as a PivotTable. |
xlQueryTable | Returns the data as a QueryTable. |
Specifies from where to copy the format for inserted cells.
Official VBA documentation for XlInsertFormatOrigin
Enumerator | |
---|---|
xlFormatFromLeftOrAbove | Copy the format from cells above and/or to the left. |
xlFormatFromRightOrBelow | Copy the format from cells below and/or to the right. |
Specifies the direction in which to shift cells during an insertion.
Official VBA documentation for XlInsertShiftDirection
Enumerator | |
---|---|
xlShiftDown | Shift cells down. |
xlShiftToRight | Shift cells to the right. |
Specifies the way the specified PivotTable items appear—in table format or in outline format.
Official VBA documentation for XlLayoutFormType
Enumerator | |
---|---|
xlOutline | The LayoutSubtotalLocation property specifies where the subtotal appears in the PivotTable report. |
xlTabular | Default. |
Specifies the type of layout row.
Official VBA documentation for XlLayoutRowType
Enumerator | |
---|---|
xlCompactRow | Compact Row |
xlOutlineRow | Outline Row |
xlTabularRow | Tabular Row |
Specifies the position of the legend on a chart.
Official VBA documentation for XlLegendPosition
Specifies the line style for the border.
Official VBA documentation for XlLineStyle
enum wxAutoExcel::XlLink |
Specifies the type of link.
Official VBA documentation for XlLink
Enumerator | |
---|---|
xlExcelLinks | The link is to an Excel worksheet. |
xlOLELinks | The link is to an OLE source. |
xlPublishers | Macintosh only. |
xlSubscribers | Macintosh only. |
Specifies the type of information the link will return.
Official VBA documentation for XlLinkInfo
Specifies the type of link.
Official VBA documentation for XlLinkInfoType
Enumerator | |
---|---|
xlLinkInfoOLELinks | OLE or DDE server |
xlLinkInfoPublishers | Publisher |
xlLinkInfoSubscribers | Subscriber |
Specifies the status of a link.
Official VBA documentation for XlLinkStatus
Specifies the type of link.
Official VBA documentation for XlLinkType
Enumerator | |
---|---|
xlLinkTypeExcelLinks | A link to a Microsoft Excel source. |
xlLinkTypeOLELinks | A link to an OLE source. |
Indicates the state of cells that may contain Linked data types such as Stocks or Geography.
These are the possible values of the Range.LinkedDataTypeState property.
Official VBA documentation for XlLinkedDataTypeState
Specifies the conflict resolution options for updating a list on a Microsoft SharePoint Foundation site with the changes made to a list in a Microsoft Excel worksheet.
Official VBA documentation for XlListConflict
Specifies the data type of a list column connected to a Microsoft SharePoint Foundation site.
Official VBA documentation for XlListDataType
Specifies the current source of the list.
Official VBA documentation for XlListObjectSourceType
Enumerator | |
---|---|
xlSrcExternal | External data source (Microsoft SharePoint Foundation site). |
xlSrcModel | PowerPivot Model |
xlSrcQuery | Query |
xlSrcRange | Range |
xlSrcXml | XML |
Specifies the part of the PivotTable report that contains the upper-left corner of a range.
Official VBA documentation for XlLocationInTable
Specifies whether a match is made against the whole of the search text or any part of the search text.
Official VBA documentation for XlLookAt
Enumerator | |
---|---|
xlPart | Match against any part of the search text. |
xlWhole | Match against the whole of the search text. |
Specifies what to look for in searches.
Official VBA documentation for XlLookFor
Enumerator | |
---|---|
LookForBlanks | Blanks |
LookForErrors | Errors |
LookForFormulas | Formulas |
Specifies a Microsoft application.
Official VBA documentation for XlMSApplication
Specifies the mail system that is installed on the host computer.
Official VBA documentation for XlMailSystem
Enumerator | |
---|---|
xlMAPI | MAPI-complaint system |
xlNoMailSystem | No mail system |
xlPowerTalk | PowerTalk mail system |
Specifies the marker style for a point or series in a line chart, scatter chart, or radar chart.
Official VBA documentation for XlMarkerStyle
Specifies the measurement units.
Official VBA documentation for XlMeasurementUnits
Enumerator | |
---|---|
xlCentimeters | Centimeters |
xlInches | Inches |
xlMillimeters | Millimeters |
Specifies the source of the change to the data model.
Official VBA documentation for XlModelChangeSource
Enumerator | |
---|---|
xlChangeByExcel | Excel |
xlChangeByPowerPivotAddIn | PowerPivot add-in |
Specifies which mouse button was pressed.
Official VBA documentation for XlMouseButton
Specifies the appearance of the mouse pointer in Excel.
Official VBA documentation for XlMousePointer
Enumerator | |
---|---|
xlDefault | The default pointer. |
xlIBeam | The I-beam pointer. |
xlNorthwestArrow | The northwest-arrow pointer. |
xlWait | The hourglass pointer. |
Specifies the OLE object type.
Official VBA documentation for XlOLEType
Enumerator | |
---|---|
xlOLEControl | ActiveX control |
xlOLEEmbed | Embedded OLE object |
xlOLELink | Linked OLE object |
Specifies the verb on which the server of the OLE object should act.
Official VBA documentation for XlOLEVerb
Enumerator | |
---|---|
xlVerbOpen | Open the object. |
xlVerbPrimary | Perform the primary action for the server. |
Specifies the horizontal overflow setting for a text frame.
Official VBA documentation for XlOartHorizontalOverflow
Enumerator | |
---|---|
xlOartHorizontalOverflowClip | Hide text that does not fit horizontally in the text frame. |
xlOartHorizontalOverflowOverflow | Allow text to overflow the text frame horizontally. |
Specifies the vertical overflow setting for a text frame.
Official VBA documentation for XlOartVerticalOverflow
Specifies the way a chart is scaled to fit on a page.
Official VBA documentation for XlObjectSize
enum wxAutoExcel::XlOrder |
Specifies the order in which cells are processed.
Official VBA documentation for XlOrder
Enumerator | |
---|---|
xlDownThenOver | Process down the rows before processing across pages or page fields to the right. |
xlOverThenDown | Process across pages or page fields to the right before moving down the rows. |
Specifies the text orientation.
Official VBA documentation for XlOrientation
Enumerator | |
---|---|
xlDownward | Text runs downward. |
xlHorizontal | Text runs horizontally. |
xlUpward | Text runs upward. |
xlVertical | Text runs downward and is centered in the cell. |
Specifies what can be selected in a PivotTable during a structured selection.
These constants can be combined to select multiple types.
Official VBA documentation for XlPTSelectionMode
Enumerator | |
---|---|
xlBlanks | Blanks |
xlButton | Buttons |
xlDataAndLabel | Data and labels |
xlDataOnly | Data |
xlFirstRow | First row |
xlLabelOnly | Label |
xlOrigin | Origin |
Specifies page break location on the worksheet.
Official VBA documentation for XlPageBreak
Enumerator | |
---|---|
xlPageBreakAutomatic | Excel will automatically add page breaks. |
xlPageBreakManual | Page breaks are manually inserted. |
xlPageBreakNone | Page breaks are not inserted on the worksheet. |
Specifies whether a page break is full screen or applies only within the print area.
Official VBA documentation for XlPageBreakExtent
Enumerator | |
---|---|
xlPageBreakFull | Full screen. |
xlPageBreakPartial | Only within print area. |
Specifies the page orientation when the worksheet is printed.
Official VBA documentation for XlPageOrientation
Enumerator | |
---|---|
xlLandscape | Landscape mode. |
xlPortrait | Portrait mode. |
Specifies the size of the paper.
Official VBA documentation for XlPaperSize
Specifies the data type of a query parameter.
Official VBA documentation for XlParameterDataType
Specifies how to determine the value of the parameter for the specified query table.
Official VBA documentation for XlParameterType
Constants passed to and returned by the Series.ParentDataLabelOption property.
Official VBA documentation for XlParentDataLabelOptions
Enumerator | |
---|---|
xlParentDataLabelOptionsBanner | Banner parent data label |
xlParentDataLabelOptionsNone | No parent data label |
xlParentDataLabelOptionsOverlapping | Overlapping parent data label |
Specifies how numeric data will be calculated with the destinations cells on the worksheet.
Official VBA documentation for XlPasteSpecialOperation
Specifies the part of the range to be pasted.
Official VBA documentation for XlPasteType
Specifies the interior pattern of a chart or interior object.
Official VBA documentation for XlPattern
Specifies the alignment for phonetic text.
Used with a Phonetic or a Phonetics object.
Official VBA documentation for XlPhoneticAlignment
Enumerator | |
---|---|
xlPhoneticAlignCenter | Centered |
xlPhoneticAlignDistributed | Distributed |
xlPhoneticAlignLeft | Left aligned |
xlPhoneticAlignNoControl | Excel controls alignment |
Specifies the type of phonetic text in a cell.
Official VBA documentation for XlPhoneticCharacterType
Enumerator | |
---|---|
xlHiragana | Hiragana |
xlKatakana | Katakana |
xlKatakanaHalf | Half-size Katakana |
xlNoConversion | No conversion |
Specifies how the picture should be copied.
Official VBA documentation for XlPictureAppearance
Enumerator | |
---|---|
xlPrinter | The picture is copied as it will look when it is printed. |
xlScreen | The picture is copied to resemble its display on the screen as closely as possible. |
Specifies how to convert a graphic.
Official VBA documentation for XlPictureConvertorType
Specifies which position on the slice to return the coordinate of.
Official VBA documentation for XlPieSliceIndex
Specifies the horizontal or vertical position of a point on a pie chart, in points, from the top or left edge of the object to the top or left edge of the chart area.
Official VBA documentation for XlPieSliceLocation
Enumerator | |
---|---|
xlHorizontalCoordinate | The horizontal coordinate (x) |
xlVerticalCoordinate | The vertical coordinate (y) |
Specifies the PivotTable entity to which the cell corresponds.
Official VBA documentation for XlPivotCellType
This enumeration specifies the conditional formatting applied for filtering values from the PivotTable object.
Official VBA documentation for XlPivotConditionScope
Enumerator | |
---|---|
xlDataFieldScope | Based on the data in the specified fields. |
xlFieldsScope | Based on the specified fields. |
xlSelectionScope | Based on the specified selection criteria. |
Specifies the type of calculation performed by a data PivotField when a custom calculation is used.
Official VBA documentation for XlPivotFieldCalculation
Specifies the type of data in the PivotTable field.
Official VBA documentation for XlPivotFieldDataType
Enumerator | |
---|---|
xlDate | Contains a date. |
xlNumber | Contains a number. |
xlText | Contains text. |
Specifies the location of the field in a PivotTable report.
Official VBA documentation for XlPivotFieldOrientation
Enumerator | |
---|---|
xlColumnField | Column |
xlDataField | Data |
xlHidden | Hidden |
xlPageField | Page |
xlRowField | Row |
Specifies whether to repeat all field item labels in a PivotTable report.
Official VBA documentation for XlPivotFieldRepeatLabels
Enumerator | |
---|---|
xlDoNotRepeatLabels | Do not repeat item labels. |
xlRepeatLabels | Repeat all item labels. |
The type of filter applied.
Official VBA documentation for XlPivotFilterType
Specifies the type of report formatting to be applied to the specified PivotTable report.
Official VBA documentation for XlPivotFormatType
Specifies the type of the PivotLine.
Official VBA documentation for XlPivotLineType
Enumerator | |
---|---|
xlPivotLineBlank | Blank line after each group. |
xlPivotLineGrandTotal | Grand Total line. |
xlPivotLineRegular | Regular PivotLine with pivot items. |
xlPivotLineSubtotal | Subtotal line. |
Specifies the maximum number of unique items allowed per PivotField.
Official VBA documentation for XlPivotTableMissingItems
Specifies the source of the report data.
Official VBA documentation for XlPivotTableSourceType
Specifies the version of a PivotTable or a PivotCache.
Creating PivotTables with a specific version ensures that tables created in Excel behave in the same manner as they did in the corresponding version of Excel.
Official VBA documentation for XlPivotTableVersionList
Specifies the way that an object is attached to its underlying cells.
Official VBA documentation for XlPlacement
Enumerator | |
---|---|
xlFreeFloating | Object is free floating. |
xlMove | Object is moved with the cells. |
xlMoveAndSize | Object is moved and sized with the cells. |
Specifies the platform on which a text file originated.
Official VBA documentation for XlPlatform
Enumerator | |
---|---|
xlMacintosh | Macintosh |
xlMSDOS | MS-DOS |
xlWindows | Microsoft Windows |
Specifies the mode for checking the spelling of Portuguese.
Official VBA documentation for XlPortugueseReform
Specifies the type of print error displayed.
Official VBA documentation for XlPrintErrors
Specifies the way that comments are printed with the sheet.
Official VBA documentation for XlPrintLocation
Specifies the priority of a SendMailer message.
Official VBA documentation for XlPriority
Enumerator | |
---|---|
xlPriorityHigh | High |
xlPriorityLow | Low |
xlPriorityNormal | Normal |
Specifies where to display the property.
Official VBA documentation for XlPropertyDisplayedIn
Specifies how the Protected View window was closed.
Official VBA documentation for XlProtectedViewCloseReason
Specifies the state of the Protected View window.
Official VBA documentation for XlProtectedViewWindowState
Enumerator | |
---|---|
xlProtectedViewWindowMaximized | Maximized |
xlProtectedViewWindowMinimized | Minimized |
xlProtectedViewWindowNormal | Normal |
Specifies the type of query used by Microsoft Excel to populate the query table or PivotTable cache.
Official VBA documentation for XlQueryType
Indicates for which top level button the callout user interface is displayed.
Official VBA documentation for XlQuickAnalysisMode
Enumerator | |
---|---|
xlLensOnly | Show the button but no callout user interface |
xlFormatConditions | Conditional Formatting |
xlRecommendedCharts | Charts |
xlTotals | Totals |
xlTables | Tables |
xlSparklines | Sparklines |
Specifies the predefined format when a range is automatically formatted.
Official VBA documentation for XlRangeAutoFormat
Specifies the range value data type.
Official VBA documentation for XlRangeValueDataType
Specifies the reference style.
Official VBA documentation for XlReferenceStyle
Enumerator | |
---|---|
xlA1 | Default. Use xlA1 to return an A1-style reference. |
xlR1C1 | Use xlR1C1 to return an R1C1-style reference. |
Specifies cell reference style when a formula is being converted.
Official VBA documentation for XlReferenceType
Constants passed to and returned by the Series.RegionLabelOptions property.
Official VBA documentation for XlRegionLabelOptions
Specifies the type information to be removed from the document information.
Official VBA documentation for XlRemoveDocInfoType
Specifies the RGB color.
Official VBA documentation for XlRgbColor
Specifies how the PivotTable cache or a query table connects to its data source.
Official VBA documentation for XlRobustConnect
Specifies whether the values corresponding to a particular data series are in rows or columns.
Official VBA documentation for XlRowCol
Enumerator | |
---|---|
xlColumns | Data series is in a row. |
xlRows | Data series is in a column. |
Specifies the automatic macro to run.
Official VBA documentation for XlRunAutoMacro
Enumerator | |
---|---|
xlAutoActivate | Auto_Activate macros |
xlAutoClose | Auto_Close macros |
xlAutoDeactivate | Auto_Deactivate macros |
xlAutoOpen | Auto_Open macros |
Specifies during file close if the file will be saved.
Official VBA documentation for XlSaveAction
Enumerator | |
---|---|
xlDoNotSaveChanges | Changes will not be saved. |
xlSaveChanges | Changes will be saved. |
Specifies the access mode for the Save As function.
Official VBA documentation for XlSaveAsAccessMode
Enumerator | |
---|---|
xlExclusive | Exclusive mode |
xlNoChange | Default (does not change the access mode) |
xlShared | Share list |
Specifies the way that conflicts are to be resolved whenever a shared workbook is updated.
Official VBA documentation for XlSaveConflictResolution
Specifies the scale type of the value axis.
Official VBA documentation for XlScaleType
Enumerator | |
---|---|
xlScaleLinear | Linear |
xlScaleLogarithmic | Logarithmic |
Specifies the search direction when searching a range.
Official VBA documentation for XlSearchDirection
Enumerator | |
---|---|
xlNext | Search for next matching value in range. |
xlPrevious | Search for previous matching value in range. |
Specifies the order in which to search the range.
Official VBA documentation for XlSearchOrder
Enumerator | |
---|---|
xlByColumns | Searches down through a column, then moves to the next column. |
xlByRows | Searches across a row, then moves to the next row. |
Specifies the extent of the search for the range.
Official VBA documentation for XlSearchWithin
Enumerator | |
---|---|
xlWithinSheet | Limit search to current sheet. |
xlWithinWorkbook | Search whole workbook. |
Specifies the series labels for the series label levels.
Official VBA documentation for XlSeriesNameLevel
Specifies the worksheet type.
Official VBA documentation for XlSheetType
Enumerator | |
---|---|
xlChart | Chart |
xlDialogSheet | Dialog sheet |
xlExcel4IntlMacroSheet | Excel version 4 international macro sheet |
xlExcel4MacroSheet | Excel version 4 macro sheet |
xlWorksheet | Worksheet |
Specifies whether the object is visible.
Official VBA documentation for XlSheetVisibility
Specifies what the bubble size represents on a bubble chart.
Official VBA documentation for XlSizeRepresents
Enumerator | |
---|---|
xlSizeIsArea | Area of the bubble. |
xlSizeIsWidth | Width of the bubble. |
Designates the type of slicer or slicer cache.
Official VBA documentation for XlSlicerCacheType
Enumerator | |
---|---|
xlSlicer | Slicer cache represents a Slicer. |
xlTimeline | Slicer cache represents a Timeline. |
Specifies the type of cross filtering used by the specified slicer cache and how it is visualized.
Official VBA documentation for XlSlicerCrossFilterType
Specifies whether items displayed in the slicer are sorted, and if they are sorted, whether they are sorted in ascending or descending order by item captions.
Official VBA documentation for XlSlicerSort
Specifies how to sort text.
Official VBA documentation for XlSortDataOption
Enumerator | |
---|---|
xlSortNormal | default. Sorts numeric and text data separately. |
xlSortTextAsNumbers | Treat text as numeric data for the sort. |
Specifies the type of sort.
Official VBA documentation for XlSortMethod
Enumerator | |
---|---|
xlPinYin | Phonetic Chinese sort order for characters. This is the default value. |
xlStroke | Sort by the quantity of strokes in each character. |
Specifies how to sort when using East Asian sorting methods.
Official VBA documentation for XlSortMethodOld
Enumerator | |
---|---|
xlCodePage | Sort by code page. |
xlSyllabary | Sort phonetically. |
Specifies the parameter on which the data should be sorted.
Official VBA documentation for XlSortOn
Enumerator | |
---|---|
SortOnCellColor | Cell color. |
SortOnFontColor | Font color. |
SortOnIcon | Icon. |
SortOnValues | Values. |
Specifies the sort order for the specified field or range.
Official VBA documentation for XlSortOrder
Specifies the sort orientation.
Official VBA documentation for XlSortOrientation
Enumerator | |
---|---|
xlSortColumns | Sorts by column. |
xlSortRows | Sorts by row. This is the default value. |
Specifies which elements are to be sorted.
Use this argument only when sorting PivotTable reports.
Official VBA documentation for XlSortType
Enumerator | |
---|---|
xlSortLabels | Sorts the PivotTable report by labels. |
xlSortValues | Sorts the PivotTable report by values. |
Identifies the source object.
Official VBA documentation for XlSourceType
Specifies the mode for checking the spelling of Spanish.
Official VBA documentation for XlSpanishModes
Enumerator | |
---|---|
xlSpanishTuteoAndVoseo | Tuteo and Voseo verb forms. |
xlSpanishTuteoOnly | Tuteo verb forms only. |
xlSpanishVoseoOnly | Voseo verb forms only. |
Specifies how the minimum or maximum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group.
Official VBA documentation for XlSparkScale
Specifies the type of sparkline.
Official VBA documentation for XlSparkType
Enumerator | |
---|---|
xlSparkColumn | A column chart sparkline. |
xlSparkColumnStacked100 | A win/loss chart sparkline. |
xlSparkLine | A line chart sparkline. |
Specifies how to plot the sparkline when the data on which it is based is in a square-shaped range.
Official VBA documentation for XlSparklineRowCol
Enumerator | |
---|---|
xlSparklineColumnsSquare | Plot the data by columns. |
xlSparklineNonSquare | The sparkline is not bound to data in a square-shaped range. |
xlSparklineRowsSquare | Plot the data by rows. |
Specifies the order in which the cells are spoken.
Official VBA documentation for XlSpeakDirection
Enumerator | |
---|---|
xlSpeakByColumns | Reads down a column, then moves to the next column. |
xlSpeakByRows | Reads across a row, then moves to the next row. |
Specifies cells with a particular type of value to include in the result.
Official VBA documentation for XlSpecialCellsValue
Enumerator | |
---|---|
xlErrors | Cells with errors. |
xlLogical | Cells with logical values. |
xlNumbers | Cells with numeric values. |
xlTextValues | Cells with text. |
Specifies the standard color scale.
Official VBA documentation for XlStdColorScale
Enumerator | |
---|---|
ColorScaleBlackWhite | Black over White. |
ColorScaleGYR | GYR. |
ColorScaleRYG | RYG. |
ColorScaleWhiteBlack | White over Black. |
Specifies the format to use when subscribing to a published edition.
Official VBA documentation for XlSubscribeToFormat
Enumerator | |
---|---|
xlSubscribeToPicture | Picture |
xlSubscribeToText | Text |
Specifies where the subtotal will be displayed on the worksheet.
Official VBA documentation for XlSubtotalLocationType
Enumerator | |
---|---|
xlAtBottom | Subtotal will be at the bottom. |
xlAtTop | Subtotal will be at the top. |
Specifies the location of the summary columns in the outline.
Official VBA documentation for XlSummaryColumn
Specifies the type of summary to be created for scenarios.
Official VBA documentation for XlSummaryReportType
Enumerator | |
---|---|
xlStandardSummary | List scenarios side by side. |
xlSummaryPivotTable | Display scenarios in a PivotTable report. |
Specifies the location of the summary rows in the outline.
Official VBA documentation for XlSummaryRow
Enumerator | |
---|---|
xlSummaryAbove | The summary row will be positioned above the detail rows in the outline. |
xlSummaryBelow | The summary row will be positioned below the detail rows in the outline. |
Specifies the first or last tab position.
Official VBA documentation for XlTabPosition
Enumerator | |
---|---|
xlTabPositionFirst | First tab position. |
xlTabPositionLast | Last tab position. |
Specifies the table style element used.
Official VBA documentation for XlTableStyleElementType
Specifies the column format for the data in the text file that you are importing into a query table.
Official VBA documentation for XlTextParsingType
Enumerator | |
---|---|
xlDelimited | Default. Indicates that the file is delimited by delimiter characters. |
xlFixedWidth | Indicates that the data in the file is arranged in columns of fixed widths. |
Specifies the delimiter to use to specify text.
Official VBA documentation for XlTextQualifier
Enumerator | |
---|---|
xlTextQualifierDoubleQuote | Double quotation mark ("). |
xlTextQualifierNone | No delimiter. |
xlTextQualifierSingleQuote | Single quotation mark ('). |
Specifies whether the visual layout of the text being imported is left-to-right or right-to-left.
Official VBA documentation for XlTextVisualLayoutType
Enumerator | |
---|---|
xlTextVisualLTR | Left-to-right |
xlTextVisualRTL | Right-to-left |
Specifies the theme color to be used.
Official VBA documentation for XlThemeColor
Specifies the theme font to use.
Official VBA documentation for XlThemeFont
Enumerator | |
---|---|
xlThemeFontMajor | Major. |
xlThemeFontMinor | Minor. |
xlThemeFontNone | Do not use any theme font. |
Specifies the control over the multi-threaded calculation mode.
Official VBA documentation for XlThreadMode
Enumerator | |
---|---|
xlThreadModeAutomatic | Multi-threaded calculation mode is automatic. |
xlThreadModeManual | Multi-threaded calculation mode is manual. |
Specifies the text orientation for tick-mark labels.
Official VBA documentation for XlTickLabelOrientation
Specifies the position of tick-mark labels on the specified axis.
Official VBA documentation for XlTickLabelPosition
Specifies the position of major and minor tick marks for an axis.
Official VBA documentation for XlTickMark
Enumerator | |
---|---|
xlTickMarkCross | Crosses the axis |
xlTickMarkInside | Inside the axis |
xlTickMarkNone | No mark |
xlTickMarkOutside | Outside the axis |
Specifies the time period.
Official VBA documentation for XlTimePeriods
Specifies the unit of time for chart axes and data series.
Official VBA documentation for XlTimeUnit
Enumerator | |
---|---|
xlDays | Days |
xlMonths | Months |
xlYears | Years |
One of the built-in hierarchy levels that Timeline supports.
Official VBA documentation for XlTimelineLevel
Enumerator | |
---|---|
xlTimelineLevelYears | Years level |
xlTimelineLevelQuarters | Quarters level |
xlTimelineLevelMonths | Months level |
xlTimelineLevelDays | Days level |
Specifies which properties of a toolbar are restricted.
Options can be combined using Or.
Official VBA documentation for XlToolbarProtection
Specifies the top 10 values from the top or bottom of a series of values.
Official VBA documentation for XlTopBottom
Enumerator | |
---|---|
xlTop10Bottom | Top 10 bottom values |
xlTop10Top | Top 10 values |
Specifies the type of calculation in the Totals row of a list column.
Official VBA documentation for XlTotalsCalculation
Specifies how the trendline that smooths out fluctuations in the data is calculated.
Official VBA documentation for XlTrendlineType
Specifies the type of underline applied to a font.
Official VBA documentation for XlUnderlineStyle
Specifies a workbook's setting for updating embedded OLE links.
Official VBA documentation for XlUpdateLinks
Specifies the vertical alignment for the object.
Official VBA documentation for XlVAlign
Enumerator | |
---|---|
xlVAlignBottom | Bottom |
xlVAlignCenter | Center |
xlVAlignDistributed | Distributed |
xlVAlignJustify | Justify |
xlVAlignTop | Top |
Specifies the type of workbook to create.
The new workbook contains a single sheet of the specified type.
Official VBA documentation for XlWBATemplate
Enumerator | |
---|---|
xlWBATChart | Chart |
xlWBATExcel4IntlMacroSheet | Excel version 4 macro |
xlWBATExcel4MacroSheet | Excel version 4 international macro |
xlWBATWorksheet | Worksheet |
Specifies how much formatting from a webpage, if any, is applied when a webpage is imported into a query table.
Official VBA documentation for XlWebFormatting
Enumerator | |
---|---|
xlWebFormattingAll | All formatting is imported. |
xlWebFormattingNone | No formatting is imported. |
xlWebFormattingRTF | Rich Text Format - compatible formatting is imported. |
Specifies whether an entire webpage, all tables on the webpage, or only a specific table is imported into a query table.
Official VBA documentation for XlWebSelectionType
Enumerator | |
---|---|
xlAllTables | All tables |
xlEntirePage | Entire page |
xlSpecifiedTables | Specified tables |
Specifies the state of the window.
Official VBA documentation for XlWindowState
Enumerator | |
---|---|
xlMaximized | Maximized |
xlMinimized | Minimized |
xlNormal | Normal |
Specifies how the chart is displayed.
Official VBA documentation for XlWindowType
Specifies the view showing in the window.
Official VBA documentation for XlWindowView
Enumerator | |
---|---|
xlNormalView | Normal. |
xlPageBreakPreview | Page break preview. |
xlPageLayoutView | Page layout view. |
Specifies, in a Microsoft Excel version 4 macro worksheet, what type of macro a name refers to or whether the name refers to a macro.
Official VBA documentation for XlXLMMacroType
Enumerator | |
---|---|
xlCommand | Custom command. |
xlFunction | Custom function. |
xlNotXLM | Not a macro. |
Specifies the results of the save or export operation.
Official VBA documentation for XlXmlExportResult
Enumerator | |
---|---|
xlXmlExportSuccess | The XML data file was successfully exported. |
xlXmlExportValidationFailed | The contents of the XML data file don't match the specified schema map. |
Specifies the results of the refresh or import operation.
Official VBA documentation for XlXmlImportResult
Specifies how Excel opens the XML data file.
Official VBA documentation for XlXmlLoadOption
Specifies whether or not the first row contains headers.
Cannot be used when sorting PivotTable reports.
Official VBA documentation for XlYesNoGuess
Enumerator | |
---|---|
xlGuess | Excel determines whether there is a header, and where it is, if there is one. |
xlNo | Default. The entire range should be sorted. |
xlYes | The entire range should not be sorted. |
Specifies constants that define the styles of the groups on the File tab.
Official VBA documentation for BackstageGroupStyle
Enumerator | |
---|---|
BackstageGroupStyleError | Error style |
BackstageGroupStyleNormal | Normal style |
BackstageGroupStyleWarning | Warning style |
Provides information about the digital certificate.
Official VBA documentation for CertificateDetail
Provides the results of verifying a digital certificate.
Official VBA documentation for CertificateVerificationResults
Provides the status of verifying whether the content of a document has changed.
Official VBA documentation for ContentVerificationResults
Specifies the mode for encryption ciphers.
Official VBA documentation for EncryptionCipherMode
Enumerator | |
---|---|
cipherModeECB | ECB cipher mode |
cipherModeCBC | CBC cipher mode |
Specifies details about encryption providers.
Official VBA documentation for EncryptionProviderDetail
Specifies how the body of the email is displayed.
Official VBA documentation for MailFormat
Enumerator | |
---|---|
mfHTML | The email is displayed as HyperText Markup Language (HTML). |
mfPlainText | The email is displayed as plain text. |
mfRTF | The email is displayed as Rich Text Format (RTF). |
Specifies behavior when the user cancels an alert.
Only msoAlertCancelDefault is currently supported.
Official VBA documentation for MsoAlertCancelType
Specifies which icon, if any, to display with an alert.
Official VBA documentation for MsoAlertIconType
Defines how to align specified objects relative to one another.
Official VBA documentation for MsoAlignCmd
Specifies a language setting in a Microsoft Office application.
The MsoAppLanguageID enumeration is used with the LanguageSettings member of the Application object to determine the language used for the install language, the user interface language, or the Help language.
Official VBA documentation for MsoAppLanguageID
Specifies the length of the arrowhead at the end of a line.
Official VBA documentation for MsoArrowheadLength
Specifies the style of the arrowhead at the end of a line.
Official VBA documentation for MsoArrowheadStyle
Specifies the width of the arrowhead at the end of a line.
Official VBA documentation for MsoArrowheadWidth
Enumerator | |
---|---|
msoArrowheadNarrow | Narrow |
msoArrowheadWide | Wide |
msoArrowheadWidthMedium | Medium |
msoArrowheadWidthMixed | Return value only; indicates a combination of the other states. |
Specifies the security mode an application uses when programmatically opening files.
Official VBA documentation for MsoAutomationSecurity
Specifies the shape type for an AutoShape object.
Official VBA documentation for MsoAutoShapeType
Determines the type of automatic sizing allowed.
Official VBA documentation for MsoAutoSize
Indicates the background style for an object.
Official VBA documentation for MsoBackgroundStyleIndex
Specifies the position or behavior of a command bar.
Official VBA documentation for MsoBarPosition
Specifies how a command bar is protected from user customization.
Official VBA documentation for MsoBarProtection
Specifies whether a command bar is in the first row or last row relative to other command bars in the same docking area.
Official VBA documentation for MsoBarRow
Enumerator | |
---|---|
msoBarRowFirst | First row of docking area. |
msoBarRowLast | Last row of docking area. |
Specifies the type of the command bar.
Official VBA documentation for MsoBarType
Enumerator | |
---|---|
msoBarTypeMenuBar | Menu bar |
msoBarTypeNormal | Default command bar |
msoBarTypePopup | Shortcut menu |
Specifies baseline text alignment.
Official VBA documentation for MsoBaselineAlignment
Indicates the bevel type of a ThreeDFormat object.
Official VBA documentation for MsoBevelType
Specifies how a shape appears when viewed in black-and-white mode.
Official VBA documentation for MsoBlackWhiteMode
Specifies how many categories are supported by the provider.
Official VBA documentation for MsoBlogCategorySupport
Enumerator | |
---|---|
msoBlogMultipleCategories | Multiple categories are supported. |
msoBlogNoCategories | No categories are supported. |
msoBlogOneCategory | One category is supported. |
Specifies blog image types.
Official VBA documentation for MsoBlogImageType
Enumerator | |
---|---|
msoBlogImageTypeGIF | GIF image |
msoBlogImageTypeJPEG | JPEG image |
msoBlogImageTypePNG | PNG image |
Specifies the application capabilities available for a document or presentation broadcasting session.
Official VBA documentation for MsoBroadcastCapabilities
Specifies the current state of a document or presentation broadcast.
Official VBA documentation for MsoBroadcastState
Enumerator | |
---|---|
BroadcastPaused | The broadcast is paused. |
BroadcastStarted | The broadcast has been started. |
NoBroadcast | The file is not being broadcasted. |
Specifies the bullet type.
Official VBA documentation for MsoBulletType
Specifies the appearance of a command bar button control.
Official VBA documentation for MsoButtonState
Enumerator | |
---|---|
msoButtonDown | Button is pressed down. |
msoButtonMixed | Button is pressed down. |
msoButtonUp | Button is not pressed down. |
Specifies the style of a command bar button.
Official VBA documentation for MsoButtonStyle
Specifies the size of the angle between the callout line and the side of the callout text box.
Official VBA documentation for MsoCalloutAngleType
Specifies the starting position of the callout line relative to the text bounding box.
Used with the PresetDrop method of the CalloutFormat object.
Official VBA documentation for MsoCalloutDropType
Specifies the type of callout line.
Official VBA documentation for MsoCalloutType
Specifies the character set to be used when rendering text.
Official VBA documentation for MsoCharacterSet
Specifies whether and how to display chart elements.
Official VBA documentation for MsoChartElementType
Specifies the type of data field to be inserted into a data label in a chart.
Official VBA documentation for MsoChartFieldType
Specifies Clipboard formats.
Official VBA documentation for MsoClipboardFormat
Specifies the color type.
Official VBA documentation for MsoColorType
Specifies whether the command bar combo box includes a label or not.
Official VBA documentation for MsoComboStyle
Enumerator | |
---|---|
msoComboLabel | Combo box includes a label, specified by the Caption property of the combo box. |
msoComboNormal | Combo box does not include a label. |
Specifies whether the command bar button is a hyperlink.
If the command bar button is a hyperlink, further specifies whether the hyperlink should launch another application such as the browser or insert a picture at the active selection point.
Official VBA documentation for MsoCommandBarButtonHyperlinkType
Specifies a type of connector.
Official VBA documentation for MsoConnectorType
Specifies the address type for a contact card.
Official VBA documentation for MsoContactCardAddressType
Specifies how the contact card is displayed.
Official VBA documentation for MsoContactCardStyle
Enumerator | |
---|---|
msoContactCardFull | The contact card is displayed as a full card. |
msoContactCardHover | The contact card is displayed as a hover card. |
Specifies the contact card type.
Official VBA documentation for MsoContactCardType
Specifies the OLE client and OLE server roles in which a command bar control is used when two Microsoft Office applications are merged.
Official VBA documentation for MsoControlOLEUsage
Specifies the type of the command bar control.
Used with the Add method of the CommandBarControls object. Only a limited set of the control types can be created via the CommandBars object model: msoControlButton, msoControlEdit, msoControlDropdown, msoControlComboBox, msoControlPopup, and msoControlActiveX. Other control types may exist on built-in or add-in command bars, but cannot be created via the object model.
Official VBA documentation for MsoControlType
Specifies the docking behavior of the custom task pane.
Official VBA documentation for MsoCTPDockPosition
Specifies restrictions on the docking behavior of the custom task pane.
Official VBA documentation for MsoCTPDockPositionRestrict
Specifies the node type.
Official VBA documentation for MsoCustomXMLNodeType
Indicates how validation errors will be cleared or generated.
Official VBA documentation for MsoCustomXMLValidationErrorType
Specifies the format of a date/time data type.
Official VBA documentation for MsoDateTimeFormat
Specifies how to evenly distribute a collection of shapes.
Used with the Distribute method of the ShapeRange collection.
Official VBA documentation for MsoDistributeCmd
Enumerator | |
---|---|
msoDistributeHorizontally | Distribute horizontally. |
msoDistributeVertically | Distribute vertically. |
Represents the results of running a Document Inspector module.
Official VBA documentation for MsoDocInspectorStatus
Specifies the data type for a document property.
Official VBA documentation for MsoDocProperties
Enumerator | |
---|---|
msoPropertyTypeBoolean | Boolean value. |
msoPropertyTypeDate | Date value. |
msoPropertyTypeFloat | Floating point value. |
msoPropertyTypeNumber | Integer value. |
msoPropertyTypeString | String value. |
Specifies the editing type of a node.
Official VBA documentation for MsoEditingType
Specifies the document encoding (code page or character set) for the web browser to use when a user views a saved document.
Official VBA documentation for MsoEncoding
Specifies how to use the value specified in the ExtraInfo parameter of the FollowHyperlink method.
Official VBA documentation for MsoExtraInfoMethod
Specifies whether the extrusion color is based on the extruded shape's fill (the front face of the extrusion) and automatically changes when the shape's fill changes, or whether the extrusion color is independent of the shape's fill.
Used with the ExtrusionColorType property of the ThreeDFormat object.
Official VBA documentation for MsoExtrusionColorType
Specifies the language to use to determine which line break level is used when the line break control option is turned on.
Official VBA documentation for MsoFarEastLineBreakLanguageID
Specifies how the application handles calls to methods and properties that require features not yet installed.
Official VBA documentation for MsoFeatureInstall
Specifies the type of a FileDialog object.
Official VBA documentation for MsoFileDialogType
Enumerator | |
---|---|
msoFileDialogFilePicker | File Picker dialog box. |
msoFileDialogFolderPicker | Folder Picker dialog box. |
msoFileDialogOpen | Open dialog box. |
msoFileDialogSaveAs | Save As dialog box. |
Specifies the view presented to the user in a file dialog box.
Official VBA documentation for MsoFileDialogView
Specifies the action to take when a user clicks an item in the task pane.
Used with the Add method of the NewFile object.
Official VBA documentation for MsoFileNewAction
Enumerator | |
---|---|
msoCreateNewFile | Create a new file. |
msoEditFile | Edit a file. |
msoOpenFile | Open a file. |
Specifies the task pane section to which to add a file or where the file reference exists.
Used with the Add method and the Remove method of the NewFile object.
Official VBA documentation for MsoFileNewSection
Enumerator | |
---|---|
msoBottomSection | Bottom section |
msoNew | New section |
msoNewfromExistingFile | New from Existing File section |
msoNewfromTemplate | New from Template section |
msoOpenDocument | Open Document section |
Specifies the file validation mode.
Official VBA documentation for MsoFileValidationMode
Enumerator | |
---|---|
msoFileValidationDefault | Validate the file (default). |
msoFileValidationSkip | Do not validate the file. |
Specifies a shape's fill type.
Official VBA documentation for MsoFillType
Specifies how the Column and CompareTo properties are compared for an ODSOFilter object.
Official VBA documentation for MsoFilterComparison
Specifies how a filter criterion relates to other filter criteria.
Used with the Conjunction property of the ODSOFilters object and with the Add method of the MailMergeFilters object.
Official VBA documentation for MsoFilterConjunction
Enumerator | |
---|---|
msoFilterConjunctionAnd | And conjunction |
msoFilterConjunctionOr | Or conjunction |
Specifies whether a shape should be flipped horizontally or vertically.
Official VBA documentation for MsoFlipCmd
Enumerator | |
---|---|
msoFlipHorizontal | Flip horizontally. |
msoFlipVertical | Flip vertically. |
Represents one of the three language fonts contained in the ThemeFonts collection.
Official VBA documentation for MsoFontLanguageIndex
Specifies the type of gradient used in a shape's fill.
Official VBA documentation for MsoGradientColorType
Specifies the style for a gradient fill.
Official VBA documentation for MsoGradientStyle
Preset graphic styles.
Official VBA documentation for MsoGraphicStyleIndex
Specifies the horizontal alignment of text in a text frame.
Used with the HorizontalAnchor property of the TextFrame object.
Official VBA documentation for MsoHorizontalAnchor
Enumerator | |
---|---|
msoAnchorCenter | Text is centered horizontally. |
msoAnchorNone | No alignment. |
msoHorizontalAnchorMixed | Return value only; indicates a combination of the other states. |
Specifies the type of hyperlink.
Official VBA documentation for MsoHyperlinkType
Specifies constants that define the IOD (install on demand) groups.
Official VBA documentation for MsoIodGroup
Enumerator | |
---|---|
msoIodGroupPIAs | PIAs group |
msoIodGroupVSTOR35Mgd | VSTO 3.5 managed group |
msoIodGroupVSTOR40Mgd | VSTO 4.0 managed group |
Specifies the language identifier.
Official VBA documentation for MsoLanguageID
Indicates the effects lighting for an object.
Official VBA documentation for MsoLightRigType
Specifies the type of line cap.
Official VBA documentation for MsoLineCapStyle
Enumerator | |
---|---|
msoLineCapFlat | Specifies a flat line cap. |
msoLineCapMixed | Specifies a mixture of line caps. |
msoLineCapRound | Specifies a rounded line cap. |
msoLineCapSquare | Specifies a squared-off line cap. |
Specifies the dash style for a line.
Official VBA documentation for MsoLineDashStyle
Specifies the type of fill for a line.
Official VBA documentation for MsoLineFillType
Specifies the type of join where two lines connect.
Official VBA documentation for MsoLineJoinStyle
Enumerator | |
---|---|
msoLineJoinBevel | Specifies a beveled join. |
msoLineJoinMiter | Specifies a mitered join. |
msoLineJoinMixed | Specifies a mixture of join types. |
msoLineJoinRound | Specifies a rounded join. |
Specifies the style for a line.
Official VBA documentation for MsoLineStyle
Specifies the animation style for Microsoft Office command bars.
Official VBA documentation for MsoMenuAnimation
Enumerator | |
---|---|
msoMenuAnimationNone | No animation |
msoMenuAnimationRandom | Random animation |
msoMenuAnimationSlide | Menus slide into view |
msoMenuAnimationUnfold | Menus unfold into view |
Specifies the output of a merge shapes operation.
Official VBA documentation for MsoMergeCmd
Specifies the metadata property type.
Official VBA documentation for MsoMetaPropertyType
Specifies numbered bullet styles.
Official VBA documentation for MsoNumberedBulletStyle
Specifies the menu group that a command bar pop-up control belongs to when the menu groups of the OLE server are merged with the menu groups of an OLE client (that is, when an object of the container application type is embedded in another application).
Official VBA documentation for MsoOLEMenuGroup
Indicates how to format the child nodes in an organization chart.
Official VBA documentation for MsoOrgChartLayoutType
Specifies orientation of an organization chart.
Official VBA documentation for MsoOrgChartOrientation
Enumerator | |
---|---|
msoOrgChartOrientationMixed | Mixed orientation |
msoOrgChartOrientationVertical | Vertical orientation |
Specifies orientation of an object when it is displayed or printed.
Official VBA documentation for MsoOrientation
Enumerator | |
---|---|
msoOrientationHorizontal | Horizontal (landscape) orientation |
msoOrientationMixed | Mixed orientation |
msoOrientationVertical | Vertical (portrait) orientation |
Specifies paragraph alignment for a text block.
Official VBA documentation for MsoParagraphAlignment
Specifies the format of a file or folder path.
Official VBA documentation for MsoPathFormat
Specifies the fill pattern used in a shape.
Official VBA documentation for MsoPatternType
Specifies an Information Rights Management (IRM) permission type for a document.
Official VBA documentation for MsoPermission
Specifies contact-picker field types.
Official VBA documentation for MsoPickerField
Specifies the color transformation applied to a picture.
Official VBA documentation for MsoPictureColorType
Specifies whether a picture will be compressed or not when inserted into a file.
Official VBA documentation for MsoPictureCompress
Specifies constants that define the types of picture effects.
Official VBA documentation for MsoPictureEffectType
Indicates the effects camera type used by the specified object.
Official VBA documentation for MsoPresetCamera
Specifies the direction that the extrusion's sweep path takes away from the extruded shape (the front face of the extrusion).
Used with the PresetExtrusionDirection property of the ThreeDFormat object.
Official VBA documentation for MsoPresetExtrusionDirection
Specifies which predefined gradient to use to fill a shape.
Official VBA documentation for MsoPresetGradientType
Specifies the location of lighting on an extruded (three-dimensional) shape relative to the shape.
Official VBA documentation for MsoPresetLightingDirection
Specifies the intensity of light used on a shape.
Official VBA documentation for MsoPresetLightingSoftness
Enumerator | |
---|---|
msoLightingBright | Bright light |
msoLightingDim | Dim light |
msoLightingNormal | Normal light |
msoPresetLightingSoftnessMixed | Not supported |
Specifies the extrusion surface material.
Used with the PresetMaterial property of the ThreeDFormat object.
Official VBA documentation for MsoPresetMaterial
Specifies what text effect to use on a WordArt object.
Refer to the WordArt Gallery dialog box in any Microsoft Office product that supports WordArt to see a preview of each effect. The values of the MsoPresetTextEffect constants correspond to the formats listed in the WordArt Gallery dialog box (numbered from left to right and from top to bottom).
Official VBA documentation for MsoPresetTextEffect
Specifies shape of WordArt text.
You can see a preview of each text effect shape by selecting WordArt Shape on the WordArt toolbar.
Official VBA documentation for MsoPresetTextEffectShape
Specifies texture to be used to fill a shape.
Official VBA documentation for MsoPresetTexture
Specifies an extrusion (three-dimensional) format.
The MsoPresetThreeDFormat constants are numbered according to the order (left to right, top to bottom) in which they are shown on the 3D Style button on the Formatting toolbar.
Official VBA documentation for MsoPresetThreeDFormat
Indicates the type of recolor to use when changing a color scheme.
Official VBA documentation for MsoRecolorType
Specifies the type of the ReflectionFormat object.
Official VBA documentation for MsoReflectionType
Specifies where a node is added to a diagram relative to existing nodes.
Official VBA documentation for MsoRelativeNodePosition
Specifies which part of the shape retains its position when the shape is scaled.
Official VBA documentation for MsoScaleFrom
Specifies the ideal screen resolution to be used to view a document in a web browser.
Official VBA documentation for MsoScreenSize
Specifies the type for a segment.
Used with the Insert and AddNodes methods of the FreeformBuilder object.
Official VBA documentation for MsoSegmentType
Enumerator | |
---|---|
msoSegmentCurve | Curve |
msoSegmentLine | Line |
Specifies the type of shadowing effect.
Official VBA documentation for MsoShadowStyle
Specifies the type of shadow displayed with a shape.The msoShadowType constants are numbered according to their order (left to right, top to bottom) within the Shadow Style set shown in the Drawing toolbar.
Official VBA documentation for MsoShadowType
Indicates the line and shape style.
Official VBA documentation for MsoShapeStyleIndex
Specifies the type of a shape or range of shapes.
Official VBA documentation for MsoShapeType
Specifies the priority for a shared workspace task.
Official VBA documentation for MsoSharedWorkspaceTaskPriority
Enumerator | |
---|---|
msoSharedWorkspaceTaskPriorityHigh | High priority |
msoSharedWorkspaceTaskPriorityLow | Low priority |
msoSharedWorkspaceTaskPriorityNormal | Normal priority |
Specifies the status of a shared workspace task.
Official VBA documentation for MsoSharedWorkspaceTaskStatus
Specifies properties of the signature subset.
These settings act as filters for signature sets.
Official VBA documentation for MsoSignatureSubset
Specifies constants that define the different ways to add a new node to the data model in SmartArt.
Official VBA documentation for MsoSmartArtNodePosition
Specifies constants that define the types of SmartArt nodes.
Official VBA documentation for MsoSmartArtNodeType
Enumerator | |
---|---|
msoSmartArtNodeTypeAssistant | Defines an assistant node, which can be used within hierarchical diagrams. |
msoSmartArtNodeTypeDefault | The default node type. |
Represents the soft edge effect in Office graphics.
Official VBA documentation for MsoSoftEdgeType
Specifies how conflicts should be resolved when synchronizing a shared document.
Used with the ResolveConflict method of the Sync object.
Official VBA documentation for MsoSyncConflictResolutionType
Specifies the type of tab stop.
Official VBA documentation for MsoTabStopType
Specifies target browser for documents viewed in a web browser.
Official VBA documentation for MsoTargetBrowser
Specifies the capitalization of the text.
Official VBA documentation for MsoTextCaps
Specifies the capitalization of text.
Official VBA documentation for MsoTextChangeCase
Indicates the type of text wrap.
Official VBA documentation for MsoTextCharWrap
Specifies the direction that text runs.
Official VBA documentation for MsoTextDirection
Specifies alignment for WordArt text.
Official VBA documentation for MsoTextEffectAlignment
Indicates the text alignment scheme used for an object.
Official VBA documentation for MsoTextFontAlign
Specifies orientation for text.
Official VBA documentation for MsoTextOrientation
Indicates the number of times a character is printed to darken the image.
Official VBA documentation for MsoTextStrike
Indicates the text alignment against tab stops or line breaks.
Official VBA documentation for MsoTextTabAlign
Indicates the type of underline for text.
Official VBA documentation for MsoTextUnderlineType
Specifies the alignment (the origin of the coordinate grid) for the tiling of the texture fill.
Official VBA documentation for MsoTextureAlignment
Specifies the texture type for the selected fill.
Official VBA documentation for MsoTextureType
Enumerator | |
---|---|
msoTexturePreset | Preset texture type |
msoTextureTypeMixed | Return value only; indicates a combination of the other states. |
msoTextureUserDefined | User-defined texture type |
Indicates the Office theme color.
Official VBA documentation for MsoThemeColorIndex
Indicates the color scheme for an Office theme.
Official VBA documentation for MsoThemeColorSchemeIndex
Specifies a tri-state value.
Official VBA documentation for MsoTriState
Enumerator | |
---|---|
msoCTrue | Not supported |
msoFalse | False |
msoTriStateMixed | Not supported |
msoTriStateToggle | Not supported |
msoTrue | True |
Specifies the vertical alignment of text in a text frame.
Used with the VerticalAnchor property of the TextFrame object.
Official VBA documentation for MsoVerticalAnchor
Indicates various image warping formats.
Official VBA documentation for MsoWarpFormat
Specifies the context under which a wizard's callback procedure is called.
Used as an argument in a callback procedure designed for use with a custom wizard.
Official VBA documentation for MsoWizardMsgType
Specifies where in the z-order a shape should be moved relative to other shapes.
Official VBA documentation for MsoZOrderCmd
Specifies constants that define the styles of the slabs on the File tab.
Official VBA documentation for OutSpaceSlabStyle
Enumerator | |
---|---|
OutSpaceSlabStyleError | Error style |
OutSpaceSlabStyleNormal | Normal style |
OutSpaceSlabStyleWarning | Warning style |
Specifies constants that define the size of the controls on the ribbon.
Official VBA documentation for RibbonControlSize
Enumerator | |
---|---|
RibbonControlSizeLarge | Large controls |
RibbonControlSizeRegular | Small controls |
Indicates additional information about a signature.
Official VBA documentation for SignatureDetail
Indicates the signature line image.
Official VBA documentation for SignatureLineImage
Enumerator | |
---|---|
siglnimgSignedInvalid | The SignedInvalid image |
siglnimgSignedValid | The SignedValid image |
siglnimgSoftwareRequired | The SoftwareRequired image |
siglnimgUnsigned | The Unsigned image |
Specifies properties of a signature provider.
Official VBA documentation for SignatureProviderDetail
Specifies properties of a signature.
Official VBA documentation for SignatureType
wxAutoExcel::WXDLLIMPEXP_DATA_WXAUTOEXCEL | ( | wxXlTribool | ) |
XlTribool instance with default state.