Table of contents
-
Microsoft Office Web Components Visual Basic Reference
- What's New
- Programming Concepts
-
Collections
- A
- B
- C
- D
- E
- F
- G
- H
- L
- N
- O
-
P
- PageFields Collection
- PageRelatedFields Collection
- PageRowsources Collection
- Panes Collection
- ParameterValues Collection
- PivotAggregates Collection
- PivotAxisMembers Collection
- PivotColumnMembers Collection
- PivotFields Collection
- PivotFieldSets Collection
- PivotMemberProperties Collection
- PivotMembers Collection
- PivotPageMembers Collection
- PivotResultGroupFields Collection
- PivotResultMemberProperties Collection
- PivotRowMembers Collection
- PivotTotals Collection
- R
- S
- W
- X
-
Objects
- A
- B
-
C
- ChartSpace Object
- ChAxis Object
- ChBorder Object
- ChCategoryLabel Object
- ChChart Object
- ChChartDraw Object
- ChChartField Object
- ChChartSpace Object
- ChDataLabel Object
- ChDataLabels Object
- ChDropZone Object
- ChErrorBars Object
- ChFont Object
- ChFormatMap Object
- ChGridlines Object
- ChInterior Object
- ChLegend Object
- ChLegendEntry Object
- ChLine Object
- ChMarker Object
- ChPlotArea Object
- ChPoint Object
- ChScaling Object
- ChScrollView Object
- ChSegment Object
- ChSegmentBoundary Object
- ChSegments Object
- ChSeries Object
- ChSurface Object
- ChTitle Object
- ChTrendline Object
- ChUserDefinedSelection Object
- Coordinate Object
- Criteria Object
- D
- E
- F
- G
- H
- I
- L
- N
- O
-
P
- PageField Object
- PageRelatedField Object
- PageRelationship Object
- PageRowsource Object
- Pane Object
- ParameterValue Object
- PivotAggregate Object
- PivotAxis Object
- PivotAxisMember Object
- PivotCell Object
- PivotColumnMember Object
- PivotData Object
- PivotDataAxis Object
- PivotDetailCell Object
- PivotDetailRange Object
- PivotField Object
- PivotFieldSet Object
- PivotFilterAxis Object
- PivotFont Object
- PivotGroupAxis Object
- PivotHyperlink Object
- PivotLabel Object
- PivotMember Object
- PivotMemberProperty Object
- PivotPageMember Object
- PivotRange Object
- PivotResultAxis Object
- PivotResultColumnAxis Object
- PivotResultDataAxis Object
- PivotResultField Object
- PivotResultFilterAxis Object
- PivotResultGroupAxis Object
- PivotResultGroupField Object
- PivotResultLabel Object
- PivotResultMemberProperty Object
- PivotResultPageAxis Object
- PivotResultRowAxis Object
- PivotRowMember Object
- PivotTable Object
- PivotTotal Object
- PivotView Object
- Protection Object
- R
- S
- T
- W
- X
-
Methods
- A
- B
- C
- D
- E
- F
- G
- H
- I
- L
- M
- N
- O
- P
- R
-
S
- Save Method
- ScrollIntoView Method
- Select Method
- Select2 Method
- SetData Method
- SetExtent Method
- SetOneColorGradient Method
- SetPatterned Method
- SetPosition Method
- SetPresetGradient Method
- SetRootRecordset Method
- SetSolid Method
- SetSpreadsheetData Method
- SetTextured Method
- SetTwoColorGradient Method
- Show Method
- ShowAbout Method
- ShowAllData Method
- ShowContextMenu Method
- ShowDetails Method
- ShowHelp Method
- SmallScroll Method
- Sort Method
- SortAscending Method
- SortDescending Method
- StartEdit Method
- T
- U
- V
-
Properties
-
A
- Active Property
- ActiveCell Property
- ActiveData Property
- ActiveObject Property
- ActivePane Property
- ActiveSheet Property
- ActiveView Property
- ActiveWindow Property
- ActiveWorkbook Property
- Address Property
- Aggregates Property
- AllGroupingDefs Property
- AllIncludeExclude Property
- AllMember Property
- AllowAdditions Property
- AllowCustomOrdering Property
- AllowDeletingColumns Property
- AllowDeletingRows Property
- AllowDeletions Property
- AllowDetails Property
- AllowEdits Property
- AllowFiltering Property
- AllowFormattingColumns Property
- AllowFormattingRows Property
- AllowGrouping Property
- AllowHeadingRename Property
- AllowInsertingColumns Property
- AllowInsertingRows Property
- AllowLayoutEvents Property
- AllowMultiFilter Property
- AllowPointRenderEvents Property
- AllowPropertyToolbox Property
- AllowRenderEvents Property
- AllowScreenTipEvents Property
- AllowSorting Property
- AllowUISelection Property
- AllPageFields Property
- AlternateDataSource Property
- AlternateRowColor Property
- AlwaysIncludeInCube Property
- AmbientLightIntensity Property
- Amount Property
- Application Property
- AspectRatio Property
- Async Property
- AutoFilter Property
- AutoFilterMode Property
- AutoFit Property
- Axes Property
- Axis Property
-
B
- BackColor Property
- BackWall Property
- BarWidth Property
- BaseName Property
- Begin Property
- BindingData Property
- BindingInProgress Property
- Bold Property
- Bookmark Property
- Border Property
- Borders Property
- Bottom Property
- BottomRight Property
- BoundField Property
- BubbleScale Property
- Build Property
- BuildNumber Property
- ButtonBorder Property
- ButtonFont Property
- ButtonInterior Property
-
C
- Calculation Property
- CalculationVersion Property
- CanQuery Property
- CanUndo Property
- CanUpdate Property
- Caption Property
- CaptionHAlignment Property
- CaptionSection Property
- CategoryLabels Property
- Cell Property
- Cells Property
- CellsEx Property
- ChartDepth Property
- ChartFields Property
- ChartLayout Property
- Charts Property
- ChartSpaceLegend Property
- ChartSpaceTitle Property
- ChartWrapCount Property
- Checked Property
- ChildAxisMembers Property
- ChildColumnMembers Property
- ChildLabel Property
- ChildMembers Property
- ChildPageMembers Property
- ChildRowMembers Property
- ChildSection Property
- Color Property
- ColorIndex Property
- Colors Property
- Column Property
- ColumnAxis Property
- ColumnHeadings Property
- ColumnMember Property
- ColumnMembers Property
- Columns Property
- ColumnWidth Property
- Commands Property
- CommandText Property
- CompareMemberCaptionsBy Property
- CompareOrderedMembersBy Property
- Connection Property
- ConnectionFile Property
- ConnectionString Property
- Constants Property
- ConsumesRecordset Property
- Control Property
- ControlSource Property
- Count Property
- Criteria Property
- Crosses Property
- CrossesAtValue Property
- CrossingAxis Property
- CSVData Property
- CSVURL Property
- CurrentArray Property
- CurrentCell Property
- CurrentRegion Property
- CurrentSection Property
- CustomGroupMembers Property
- CustomGroupType Property
-
D
- DashStyle Property
- Data Property
- DataAxis Property
- DataBodyRange Property
- DataEntry Property
- DataField Property
- DataLabel Property
- DataLabelsCollection Property
- DataMember Property
- DataPage Property
- DataPages Property
- DataPageSize Property
- DataSource Property
- DataSourceName Property
- DataSourceType Property
- DataType Property
- DefaultColor Property
- DefaultControlType Property
- DefaultMember Property
- DefaultQueryOnLoad Property
- DefaultRecordset Property
- DefaultSort Property
- DefaultValue Property
- DesignMode Property
- DetailAutoFit Property
- DetailBackColor Property
- DetailCells Property
- DetailColumnCount Property
- DetailFont Property
- DetailForeColor Property
- DetailHAlignment Property
- DetailLeft Property
- DetailLeftOffset Property
- DetailMaxHeight Property
- DetailMaxWidth Property
- DetailRange Property
- DetailRowCount Property
- DetailRowHeight Property
- DetailsExpanded Property
- DetailSortOrder Property
- DetailTop Property
- DetailTopOffset Property
- DetailWidth Property
- Direction Property
- DirectionalLightInclination Property
- DirectionalLightIntensity Property
- DirectionalLightRotation Property
- Dirty Property
- DisplayAlert Property
- DisplayAlerts Property
- DisplayCalculatedMembers Property
- DisplayColumnHeadings Property
- DisplayCustomHeadings Property
- DisplayDesignTimeUI Property
- DisplayEmptyMembers Property
- DisplayExpandIndicator Property
- DisplayFieldButtons Property
- DisplayFieldList Property
- DisplayGridlines Property
- DisplayHeadings Property
- DisplayHorizontalScrollBar Property
- DisplayIn Property
- DisplayInFieldList Property
- DisplayOfficeLogo Property
- DisplayPropertyToolbox Property
- DisplayRowHeadings Property
- DisplayScreenTips Property
- DisplayTitleBar Property
- DisplayToolbar Property
- DisplayTotal Property
- DisplayVerticalScrollBar Property
- DisplayWorkbookTabs Property
- DisplayZeros Property
- Divisions Property
- DrawType Property
-
E
- EditMode Property
- ElementExtensions Property
- ElementID Property
- EnableAutoFilter Property
- Enabled Property
- EnableEvents Property
- EnableResize Property
- EnableUndo Property
- End Property
- EndStyle Property
- EntireColumn Property
- EntireRow Property
- Error Property
- ErrorBarsCollection Property
- ExcludedMembers Property
- ExpandDetails Property
- Expanded Property
- ExpandedByDefault Property
- ExpandMembers Property
- Explosion Property
- Expression Property
- ExtrudeAngle Property
-
F
- Field Property
- FieldLabelBackColor Property
- FieldLabelFont Property
- FieldLabelForeColor Property
- FieldLabelHeight Property
- Fields Property
- FieldSet Property
- FieldSets Property
- FieldType Property
- FillType Property
- Filter Property
- FilterAxis Property
- FilterCaption Property
- FilterContext Property
- FilterCrossJoins Property
- FilterFunction Property
- FilterFunctionValue Property
- FilterMode Property
- FilterOn Property
- FilterOnScope Property
- Filters Property
- FindAxisMember Property
- FindColumnMember Property
- FindMember Property
- FindPageMember Property
- FindRowMember Property
- FirstSection Property
- FirstSliceAngle Property
- Floor Property
- Font Property
- FontName Property
- ForeColor Property
- Format Property
- FormatMap Property
- Formula Property
- FormulaArray Property
- FormulaLocal Property
- FreezePanes Property
- Function Property
-
G
- GapDepth Property
- GapWidth Property
- GradientDegree Property
- GradientStyle Property
- GradientVariant Property
- GridlineColor Property
- GridlineColorIndex Property
- GridX Property
- GridY Property
- GroupedAutoFit Property
- GroupedBackColor Property
- GroupedFont Property
- GroupedForeColor Property
- GroupedHAlignment Property
- GroupedHeight Property
- GroupedWidth Property
- GroupEnd Property
- GroupField Property
- GroupFields Property
- GroupFilterControl Property
- GroupFilterField Property
- GroupFooter Property
- GroupHeader Property
- GroupingDefs Property
- GroupingTotalFunction Property
- GroupingType Property
- GroupingUnit Property
- GroupingUnitType Property
- GroupInterval Property
- GroupLevel Property
- GroupLevels Property
- GroupOn Property
- GroupStart Property
-
H
- HAlignment Property
- HasAbsoluteLabels Property
- HasArray Property
- HasAutoAspectRatio Property
- HasAutoCaption Property
- HasAutoChartDepth Property
- HasAutoDivisions Property
- HasAutoMajorUnit Property
- HasAutoMaximum Property
- HasAutoMinimum Property
- HasAutoMinorUnit Property
- HasBubbleSize Property
- HasCategoryName Property
- HasChartSpaceLegend Property
- HasChartSpaceTitle Property
- HasDetails Property
- HasDiscreteDivisions Property
- HasFormula Property
- HasLegend Property
- HasMajorGridlines Property
- HasMinorGridlines Property
- HasMultipleCharts Property
- HasPassiveAlerts Property
- HasPercentage Property
- HasPlotDetails Property
- HasRuntimeSelection Property
- HasSelectionMarks Property
- HasSeriesByRows Property
- HasSeriesName Property
- HasSplit Property
- HasTickLabels Property
- HasTitle Property
- HasUnifiedScales Property
- HasValue Property
- HeaderBackColor Property
- HeaderFont Property
- HeaderForeColor Property
- HeaderHAlignment Property
- HeaderHeight Property
- HeaderRowRange Property
- Height Property
- HeightRatio Property
- Hidden Property
- HoleSize Property
- HorizontalAlignment Property
- HorizontalExtent Property
- HorizontalExtentMax Property
- HorizontalPosition Property
- HTMLContainer Property
- HTMLData Property
- HTMLURL Property
- Hwnd Property
- Hyperlink Property
-
I
- id Property
- Inclination Property
- Include Property
- IncludedMembers Property
- Index Property
- InsertRowRange Property
- Interior Property
- InternalPivotTable Property
- International Property
- IsConsistent Property
- IsDataBound Property
- IsDirty Property
- IsDisplayingEquation Property
- IsDisplayingRSquared Property
- IsExpanded Property
- IsFiltered Property
- IsFilterOn Property
- IsHyperlink Property
- IsIncluded Property
- IsTotal Property
- IsValid Property
- Italic Property
- Item Property
- ItemCount Property
- J
-
L
- Label Property
- LanguageID Property
- LanguagePreferredForEditing Property
- LanguageSettings Property
- Left Property
- Left2 Property
- LeftOffset Property
- Legend Property
- LegendEntries Property
- Length Property
- Level Property
- LevelCount Property
- LightNormal Property
- Line Property
- LineStyle Property
- ListBoundField Property
- ListDisplayField Property
- ListObject Property
- ListObjects Property
- ListRows Property
- ListRowSource Property
- LoadMode Property
- Location Property
- Locked Property
- LogBase Property
- LookupRelationships Property
- LookupSchemaRelationships Property
-
M
- MajorGridlines Property
- MajorTickMarks Property
- MajorUnit Property
- MajorVersion Property
- ManySide Property
- MapData Property
- Marker Property
- MaxHeight Property
- Maximum Property
- MaxRecords Property
- MaxWidth Property
- Member Property
- MemberCaptions Property
- MemberProperties Property
- MemberPropertiesOrder Property
- MemberProperty Property
- MergeArea Property
- MergeCells Property
- Minimum Property
- MinorGridlines Property
- MinorTickMarks Property
- MinorUnit Property
- MinorVersion Property
- Miter Property
- MoveAfterReturn Property
- MoveAfterReturnDirection Property
- N
- O
-
P
- PageAxis Property
- PageFields Property
- PageMember Property
- PageRelatedFields Property
- PageRowsource Property
- PageRowsources Property
- Panes Property
- ParameterValues Property
- Parent Property
- ParentAxisMember Property
- ParentColumnMember Property
- ParentLabel Property
- ParentMember Property
- ParentPageMember Property
- ParentRecordsetDef Property
- ParentRowMember Property
- ParentSection Property
- Path Property
- Pattern Property
- PercentComplete Property
- Period Property
- Perspective Property
- PivotAxis Property
- PivotObject Property
- PlotAllAggregates Property
- PlotArea Property
- Points Property
- Position Property
- Precision Property
- PrefixCharacter Property
- PresetGradientType Property
- PresetTexture Property
- Previous Property
- PreviousSection Property
- PreviousSibling Property
- PrimaryPageRowsource Property
- PrintQuality3D Property
- ProjectionMode Property
- PropertyCaptionFont Property
- PropertyCaptionHAlignment Property
- PropertyCaptionWidth Property
- PropertyHeight Property
- PropertyValueFont Property
- PropertyValueHAlignment Property
- PropertyValueWidth Property
- PropNames Property
- ProtectContents Property
- Protection Property
- ProtectionMode Property
- ProtectStructure Property
- ProviderFormattedValue Property
- ProviderType Property
-
R
- Range Property
- RangeSelection Property
- ReadingOrder Property
- RecordNavigationSection Property
- RecordSelector Property
- Recordset Property
- RecordsetDef Property
- RecordsetDefs Property
- RecordsetLabel Property
- RecordsetType Property
- RecordSource Property
- RefersTo Property
- RefersToLocal Property
- RefersToRange Property
- ResyncCommand Property
- ReturnValue Property
- RevisionNumber Property
- Right Property
- RightToLeft Property
- Rotation Property
- Row Property
- RowAxis Property
- RowHeadings Property
- RowHeight Property
- RowMember Property
- RowMembers Property
- Rows Property
-
S
- Scaling Property
- Scalings Property
- SchemaFields Property
- SchemaParameters Property
- SchemaRelatedFields Property
- SchemaRelationships Property
- SchemaRowsources Property
- ScreenUpdating Property
- ScrollColumn Property
- ScrollRow Property
- ScrollView Property
- Section Property
- Segments Property
- SelectedSheets Property
- Selection Property
- SelectionCollection Property
- SelectionType Property
- Separator Property
- SeriesCollection Property
- ServerFilter Property
- Sheets Property
- ShowAll Property
- ShowAs Property
- ShowAsValue Property
- ShowDelButton Property
- ShowFilterBySelectionButton Property
- ShowFirstButton Property
- ShowHelpButton Property
- ShowLabel Property
- ShowLastButton Property
- ShowNewButton Property
- ShowNextButton Property
- ShowPrevButton Property
- ShowSaveButton Property
- ShowSortAscendingButton Property
- ShowSortDescendingButton Property
- ShowToggleFilterButton Property
- ShowUndoButton Property
- SideWall Property
- Size Property
- SizeRepresents Property
- SolveOrder Property
- SortDirection Property
- SortOn Property
- SortOnScope Property
- Source Property
- SourceAxis Property
- SourceColumnAxis Property
- SourceDataAxis Property
- SourceField Property
- SourceFilterAxis Property
- SourceLabel Property
- SourceMember Property
- SourcePageAxis Property
- SourceRowAxis Property
- SplitMaximum Property
- SplitMinimum Property
- StandardHeight Property
- StandardWidth Property
- Status Property
- Style Property
- SubAddress Property
- SublistRelationships Property
- SublistSchemaRelationships Property
- SubtotalBackColor Property
- SubtotalFont Property
- SubtotalForeColor Property
- SubtotalLabelBackColor Property
- SubtotalLabelFont Property
- SubtotalLabelForeColor Property
- SubtotalLabelHAlignment Property
- Subtotals Property
-
T
- TabRatio Property
- Text Property
- TextureFormat Property
- TextureName Property
- TexturePlacement Property
- TextureStackUnit Property
- Thickness Property
- TickLabelSpacing Property
- TickLabelUnitType Property
- TickMarkSpacing Property
- TickMarkUnitType Property
- TimeValue Property
- TipText Property
- Title Property
- TitleBar Property
- Toolbar Property
- Top Property
- Top2 Property
- TopLeft Property
- TopOffset Property
- Total Property
- TotalAllMembers Property
- TotalBackColor Property
- TotalColumnMember Property
- TotalFont Property
- TotalForeColor Property
- TotalMember Property
- TotalOrientation Property
- TotalPageMember Property
- TotalRowHeight Property
- TotalRowMember Property
- Totals Property
- TotalType Property
- Type Property
- U
-
V
- Value Property
- Value2 Property
- ValueType Property
- Version Property
- VerticalAlignment Property
- VerticalExtent Property
- VerticalExtentMax Property
- VerticalPosition Property
- View Property
- ViewableRange Property
- ViewOnlyMode Property
- ViewportLeft Property
- ViewportTop Property
- Visible Property
- VisibleRange Property
- W
- X
- Y
- Z
-
A
-
Events
- A
-
B
- BeforeCollapse Event
- BeforeContextMenu Event
- BeforeDelete Event
- BeforeExpand Event
- BeforeFirstPage Event
- BeforeInitialBind Event
- BeforeInsert Event
- BeforeKeyDown Event
- BeforeKeyPress Event
- BeforeKeyUp Event
- BeforeLastPage Event
- BeforeNextPage Event
- BeforeOverwrite Event
- BeforePreviousPage Event
- BeforeRender Event
- BeforeScreenTip Event
- BeforeUpdate Event
- BindingAdded Event
- BindingCompleted Event
- BindingDeleted Event
- BindingError Event
- BindingUpdated Event
- ButtonClick Event
- C
- D
- E
- F
- I
- K
- L
- M
- P
- Q
- R
- S
- U
- V
- Enumerations