オブジェクト一覧
2020年7月22日
ExcelVbaObject
| オブジェクト名 | コレクション | 親オブジェクト | 説明 |
|---|---|---|---|
| AboveAverage | |||
| Action | |||
| AddIn | |||
| AddIns | |||
| AddIns2 | |||
| Adjustments | |||
| AllowEditRange | |||
| AllowEditRanges | |||
| Application | Excel アプリケーション全体を表します。 |
||
| Areas | Areas | Range | 選択範囲内にある領域 |
| Author | |||
| AutoCorrect | |||
| AutoFilter | 指定されたワークシートのオートフィルターを示します。 |
||
| AutoRecover | |||
| Axes | |||
| Axis | |||
| AxisTitle | |||
| Border | |||
| Borders | |||
| CalculatedFields | |||
| CalculatedItems | |||
| CalculatedMember | |||
| CalculatedMembers | |||
| CalloutFormat | |||
| CategoryCollection | |||
| CellFormat | |||
| Characters | |||
| Chart | |||
| ChartArea | |||
| ChartCategory | |||
| ChartFormat | |||
| ChartGroup | |||
| ChartGroups | |||
| ChartObject | |||
| ChartObjects | |||
| Charts | |||
| ChartTitle | |||
| ChartView | |||
| ColorFormat | |||
| ColorScale | |||
| ColorScaleCriteria | |||
| ColorScaleCriterion | |||
| ColorStop | |||
| ColorStops | |||
| Comment | |||
| Comments | |||
| CommentsThreaded | |||
| CommentThreaded | |||
| ConditionValue | |||
| Connections | |||
| ConnectorFormat | |||
| ControlFormat | |||
| CubeField | |||
| CubeFields | |||
| CustomProperties | |||
| CustomProperty | |||
| CustomView | |||
| CustomViews | |||
| DataBar | |||
| DataBarBorder | |||
| DataFeedConnection | |||
| DataLabel | |||
| DataLabels | |||
| DataTable | |||
| DefaultWebOptions | |||
| Dialog | Excel の組み込みダイアログ ボックスを表します。 |
||
| Dialogs | |||
| DialogSheetView | |||
| DisplayFormat | |||
| DisplayUnitLabel | |||
| DownBars | |||
| DropLines | |||
| Error | セル範囲のスプレッドシート エラーを表します。 |
||
| ErrorBars | |||
| ErrorCheckingOptions | |||
| Errors | |||
| FileExportConverter | |||
| FileExportConverters | |||
| FillFormat | |||
| Filter | 一列に対するフィルターを表します。 |
||
| Filters | |||
| Floor | |||
| Font | オブジェクトのフォント属性 (フォント名、フォント サイズ、色など) の全体を表します。 |
||
| FormatColor | |||
| FormatCondition | |||
| FormatConditions | |||
| FreeformBuilder | |||
| FullSeriesCollection | |||
| Graphic | |||
| Gridlines | |||
| GroupShapes | |||
| HeaderFooter | |||
| HiLoLines | |||
| HPageBreak | |||
| HPageBreaks | |||
| Hyperlink | ハイパーリンクを表します。 |
||
| Hyperlinks | |||
| Icon | |||
| IconCriteria | |||
| IconCriterion | |||
| IconSet | |||
| IconSetCondition | |||
| IconSets | |||
| Interior | |||
| IRtdServer | |||
| IRTDUpdateEvent | |||
| LeaderLines | |||
| Legend | |||
| LegendEntries | |||
| LegendEntry | |||
| LegendKey | |||
| LinearGradient | |||
| LineFormat | |||
| LinkFormat | |||
| ListColumn | |||
| ListColumns | |||
| ListDataFormat | |||
| ListObject | |||
| ListObjects | |||
| ListRow | |||
| ListRows | |||
| Mailer | |||
| Model | |||
| Model3DFormat | |||
| ModelChanges | |||
| ModelColumnChange | |||
| ModelColumnChanges | |||
| ModelColumnName | |||
| ModelColumnNames | |||
| ModelConnection | |||
| ModelFormatBoolean | |||
| ModelFormatCurrency | |||
| ModelFormatDate | |||
| ModelFormatDecimalNumber | |||
| ModelFormatGeneral | |||
| ModelFormatPercentageNumber | |||
| ModelFormatScientificNumber | |||
| ModelFormatWholeNumber | |||
| ModelMeasure | |||
| ModelMeasureName | |||
| ModelMeasureNames | |||
| ModelMeasures | |||
| ModelRelationship | |||
| ModelRelationships | |||
| ModelTable | |||
| ModelTableColumn | |||
| ModelTableColumns | |||
| ModelTableNameChange | |||
| ModelTableNameChanges | |||
| ModelTableNames | |||
| ModelTables | |||
| ModuleView | |||
| MultiThreadedCalculation | |||
| Name | |||
| Names | |||
| NegativeBarFormat | |||
| ODBCConnection | |||
| ODBCError | |||
| ODBCErrors | |||
| OLEDBConnection | |||
| OLEDBError | |||
| OLEDBErrors | |||
| OLEFormat | |||
| OLEObject | |||
| OLEObjects | |||
| Outline | |||
| Page | |||
| Pages | |||
| PageSetup | |||
| Pane | |||
| Panes | |||
| Parameter | |||
| Parameters | |||
| Phonetic | |||
| Phonetics | |||
| PictureFormat | |||
| PivotAxis | |||
| PivotCache | |||
| PivotCaches | |||
| PivotCell | |||
| PivotField | |||
| PivotFields | |||
| PivotFilter | |||
| PivotFilters | |||
| PivotFormula | |||
| PivotFormulas | |||
| PivotItem | |||
| PivotItemList | |||
| PivotItems | |||
| PivotLayout | |||
| PivotLine | |||
| PivotLineCells | |||
| PivotLines | |||
| PivotTable | |||
| PivotTableChangeList | |||
| PivotTables | |||
| PivotValueCell | |||
| PlotArea | |||
| Point | |||
| Points | |||
| ProtectedViewWindow | |||
| ProtectedViewWindows | |||
| Protection | |||
| PublishObject | |||
| PublishObjects | |||
| Queries | |||
| QueryTable | |||
| QueryTables | |||
| QuickAnalysis | |||
| Range | セル、行、列、連続した1つ以上のセルブロックを含むセルの選択、または3D範囲を表します。 |
||
| Ranges | |||
| RecentFile | |||
| RecentFiles | |||
| RectangularGradient | |||
| Research | |||
| RoutingSlip | |||
| RTD | |||
| Scenario | |||
| Scenarios | |||
| Series | |||
| SeriesCollection | |||
| SeriesLines | |||
| ServerViewableItems | |||
| ShadowFormat | |||
| Shape | |||
| ShapeNode | |||
| ShapeNodes | |||
| ShapeRange | |||
| Shapes | 指定されたシートのすべての**Shape** オブジェクトのコレクションです。 |
||
| Sheets | 指定されたブックまたは作業中のブックにあるすべてのシートのコレクションです。 |
||
| SheetViews | |||
| Slicer | |||
| SlicerCache | |||
| SlicerCacheLevel | |||
| SlicerCacheLevels | |||
| SlicerCaches | |||
| SlicerItem | |||
| SlicerItems | |||
| SlicerPivotTables | |||
| Slicers | |||
| Sort | さまざまなデータの並べ替えを表します。 |
||
| SortField | |||
| SortFields | |||
| SparkAxes | |||
| SparkColor | |||
| SparkHorizontalAxis | |||
| Sparkline | |||
| SparklineGroup | |||
| SparklineGroups | |||
| SparkPoints | |||
| SparkVerticalAxis | |||
| Speech | |||
| SpellingOptions | |||
| Style | セル範囲のスタイル全体を表します。 |
||
| Styles | |||
| Tab | |||
| TableObject | |||
| TableStyle | |||
| TableStyleElement | |||
| TableStyleElements | |||
| TableStyles | |||
| TextConnection | |||
| TextEffectFormat | |||
| TextFrame | |||
| TextFrame2 | |||
| ThreeDFormat | |||
| TickLabels | |||
| TimelineState | |||
| TimelineViewState | |||
| Top10 | |||
| TreeviewControl | |||
| Trendline | |||
| Trendlines | |||
| UniqueValues | |||
| UpBars | |||
| UsedObjects | |||
| UserAccess | |||
| UserAccessList | |||
| Validation | |||
| ValueChange | |||
| VPageBreak | |||
| VPageBreaks | |||
| Walls | |||
| Watch | |||
| Watches | |||
| WebOptions | |||
| Window | ウィンドウを表します。 |
||
| Windows | |||
| Workbook | Microsoft Excel ブックを表します。 |
||
| WorkbookConnection | |||
| WorkbookQuery | |||
| Workbooks | |||
| Worksheet | ワークシートを表します。 |
||
| WorksheetDataConnection | |||
| WorksheetFunction | |||
| Worksheets | |||
| WorksheetView | |||
| XmlDataBinding | |||
| XmlMap | |||
| XmlMaps | |||
| XmlNamespace | |||
| XmlNamespaces | |||
| XmlSchema | |||
| XmlSchemas | |||
| XPath |