Table of contents
Table of contents +
Introduction to Excel VBA
Concepts
Object model
AboveAverage Object
Action Object
Actions Object
AddIn Object
AddIns Object
AddIns2 Object
Adjustments Object
AllowEditRange Object
AllowEditRanges Object
Application Object
Areas Object
AutoCorrect Object
AutoFilter Object
AutoRecover Object
Axes Object
Axis Object
AxisTitle Object
Border Object
Borders Object
CalculatedFields Object
CalculatedItems Object
CalculatedMember Object
CalculatedMembers Object
CalloutFormat Object
CategoryCollection Object
CellFormat Object
Characters Object
Chart Object
ChartArea Object
ChartCategory Object
ChartFormat Object
ChartGroup Object
ChartGroups Object
ChartObject Object
ChartObjects Object
Charts Object
ChartTitle Object
ChartView Object
ColorFormat Object
ColorScale Object
ColorScaleCriteria Object
ColorScaleCriterion Object
ColorStop Object
ColorStops Object
Comment Object
Comments Object
ConditionValue Object
Connections Object
ConnectorFormat Object
ControlFormat Object
CubeField Object
CubeFields Object
CustomProperties Object
CustomProperty Object
CustomView Object
CustomViews Object
Databar Object
DataBarBorder Object
DataFeedConnection Object
DataLabel Object
DataLabels Object
DataTable Object
DefaultWebOptions Object
Dialog Object
Dialogs Object
DialogSheetView Object
DisplayFormat Object
DisplayUnitLabel Object
DownBars Object
DropLines Object
Error Object
ErrorBars Object
ErrorCheckingOptions Object
Errors Object
FileExportConverter Object
FileExportConverters Object
FillFormat Object
Filter Object
Filters Object
Floor Object
Font Object
FormatColor Object
FormatCondition Object
FormatConditions Object
FreeformBuilder Object
FullSeriesCollection Object
Graphic Object
Gridlines Object
GroupShapes Object
HeaderFooter Object
HiLoLines Object
HPageBreak Object
HPageBreaks Object
Hyperlink Object
Hyperlinks Object
Icon Object
IconCriteria Object
IconCriterion Object
IconSet Object
IconSetCondition Object
IconSets Object
Interior Object
IRtdServer Object
IRTDUpdateEvent Object
LeaderLines Object
Legend Object
LegendEntries Object
LegendEntry Object
LegendKey Object
LinearGradient Object
LineFormat Object
LinkFormat Object
ListColumn Object
ListColumns Object
ListDataFormat Object
ListObject Object
ListObjects Object
ListRow Object
ListRows Object
Mailer Object
ModelChanges Object
ModelColumnChange Object
ModelColumnChanges Object
ModelColumnName Object
ModelColumnNames Object
ModelConnection Object
ModelFormatBoolean Object
ModelFormatCurrency Object
ModelFormatDate Object
ModelFormatDecimalNumber Object
ModelFormatGeneral Object
ModelFormatPercentageNumber Object
ModelFormatScientificNumber Object
ModelFormatWholeNumber Object
ModelMeasure Object
ModelMeasureName Object
ModelMeasureNames Object
ModelMeasures Object
ModelRelationship Object
ModelRelationships Object
ModelTable Object
ModelTableColumn Object
ModelTableColumns Object
ModelTableNameChange Object
ModelTableNameChanges Object
ModelTableNames Object
ModelTables Object
ModuleView Object
MultiThreadedCalculation Object
Name Object
Names Object
NegativeBarFormat Object
ODBCConnection Object
ODBCError Object
ODBCErrors Object
OLEDBConnection Object
OLEDBError Object
OLEDBErrors Object
OLEFormat Object
OLEObject Object
OLEObjects Object
Outline Object
Page Object
Pages Object
PageSetup Object
Pane Object
Panes Object
Parameter Object
Parameters Object
Phonetic Object
Phonetics Object
PictureFormat Object
PivotAxis Object
PivotCache Object
PivotCaches Object
PivotCell Object
PivotField Object
PivotFields Object
PivotFilter Object
PivotFilters Object
PivotFormula Object
PivotFormulas Object
PivotItem Object
PivotItemList Object
PivotItems Object
PivotLayout Object
PivotLine Object
PivotLineCells Object
PivotLines Object
PivotTable Object
PivotTableChangeList Object
PivotTables Object
PivotValueCell Object
PlotArea Object
Point Object
Points Object
ProtectedViewWindow Object
ProtectedViewWindows Object
Protection Object
PublishObject Object
PublishObjects Object
Queries Object
QueryTable Object
QueryTables Object
QuickAnalysis Object
Range Object
Ranges Object
RecentFile Object
RecentFiles Object
RectangularGradient Object
Research Object
RoutingSlip Object
RTD Object
Scenario Object
Scenarios Object
Series Object
SeriesCollection Object
SeriesLines Object
ServerViewableItems Object
ShadowFormat Object
Shape Object
Adjustments Property
AlternativeText Property
Application Property
AutoShapeType Property
BackgroundStyle Property
BlackWhiteMode Property
BottomRightCell Property
Callout Property
Chart Property
Child Property
ConnectionSiteCount Property
Connector Property
ConnectorFormat Property
ControlFormat Property
Creator Property
Fill Property
FormControlType Property
Glow Property
GroupItems Property
HasChart Property
HasSmartArt Property
Height Property
HorizontalFlip Property
Hyperlink Property
ID Property
Left Property
Line Property
LinkFormat Property
LockAspectRatio Property
Locked Property
Name Property
Nodes Property
OLEFormat Property
OnAction Property
Parent Property
ParentGroup Property
PictureFormat Property
Placement Property
Reflection Property
Rotation Property
Shadow Property
ShapeStyle Property
SmartArt Property
SoftEdge Property
TextEffect Property
TextFrame Property
TextFrame2 Property
ThreeD Property
Title Property
Top Property
TopLeftCell Property
Type Property
VerticalFlip Property
Vertices Property
Visible Property
Width Property
ZOrderPosition Property
Apply Method
Copy Method
CopyPicture Method
Cut Method
Delete Method
Duplicate Method
Flip Method
IncrementLeft Method
IncrementRotation Method
IncrementTop Method
PickUp Method
RerouteConnections Method
ScaleHeight Method
ScaleWidth Method
Select Method
SetShapesDefaultProperties Method
Ungroup Method
ZOrder Method
ShapeNode Object
ShapeNodes Object
ShapeRange Object
Shapes Object
Sheets Object
SheetViews Object
Slicer Object
SlicerCache Object
SlicerCacheLevel Object
SlicerCacheLevels Object
SlicerCaches Object
SlicerItem Object
SlicerItems Object
SlicerPivotTables Object
Slicers Object
Sort Object
SortField Object
SortFields Object
SparkAxes Object
SparkColor Object
SparkHorizontalAxis Object
Sparkline Object
SparklineGroup Object
SparklineGroups Object
SparkPoints Object
SparkVerticalAxis Object
Speech Object
SpellingOptions Object
Style Object
Styles Object
Tab Object
TableObject Object
TableStyle Object
TableStyleElement Object
TableStyleElements Object
TableStyles Object
TextConnection Object
TextEffectFormat Object
TextFrame Object
TextFrame2 Object
ThreeDFormat Object
TickLabels Object
TimelineState Object
TimelineViewState Object
Top10 Object
TreeviewControl Object
Trendline Object
Trendlines Object
UniqueValues Object
UpBars Object
UsedObjects Object
UserAccess Object
UserAccessList Object
Validation Object
ValueChange Object
VPageBreak Object
VPageBreaks Object
Walls Object
Watch Object
Watches Object
WebOptions Object
Window Object
Windows Object
Workbook Object