首页 > 代码库 > 【Excel&VBA】VBA对象体系
【Excel&VBA】VBA对象体系
VBA对象体系
| 常用属性 | 常用方法 | 常用事件 | |
| ActiveCell | OnWindow | Calculate | SheetActive |
| ActiveSheet | Path | ConvertFormula | SheetDeactive |
| ActiveWindow | PathSeparator | OnKey | SheetFollowHyperlink |
| ActiveWorkbook | Range | InputBox | WindowActive |
| AskToUpdateLinks | Rows | Run | WindowDeactivate |
| Assistant | ScreenUpdating | WorkbookActivate | |
| AutoRecover | Selection | WorkbookBeforeClose | |
| Caption | Sheets | WorkbookOpen | |
| Cells | ShowWindowsInTaskbar | ||
| Charts | StandardFont | ||
| Columns | StandardFontSize | ||
| CommandBars | StartupPath | ||
| CommandUnderlines | StatusBar | ||
| Creator | ThisCell | ||
| Cursor | ThisWorkbook | ||
| DefaultFilePath | UserControl | ||
| DefaultSaveFormat | Workbooks | ||
| DisplayFormulabar | Worksheets | ||
| DisplayFullScreen | DisplayScrollBars | ||
| Name | DisplayStatusBar |
| 属性 | 方法 |
| Application | Add |
| Count | Close |
| Creator | Open |
| Item | OpenDatabase |
| Parent | OpenText |
| 属性 | 方法 | 事件 |
| Charts | Active | Activate |
| CodeName | Close | BeforeClose |
| FullName | Protect | Open |
| FullNameURLEncoded | ProtectSharing | SheetActivate |
| HasPassword | RunAutoMacros | SheetDeactivate |
| InactiveListBorderVisible | Save | SheetFollowHyperlink |
| Password | SaveAs | WindowActivate |
| Path | SaveCopyAs | WindowDeactivate |
| ProtectStructure | Unprotect | |
| ProtectWindows | Add | |
| ReadOnly | ||
| Saved | ||
| Sheets | ||
| Windows | ||
| Worksheets | ||
| WritePassword |
| 属性 | 方法 |
| Application | Add |
| Count | Copy |
| HPageBreaks | Delete |
| Item | FillAcrossSheets |
| Parent | Move |
| Visible | PrintOut |
| VPageBreaks | Select |
| 属性 | 方法 | 事件 |
| Application | Activate | Activate |
| AutoFilter | Calculate | BeforeDoubleClick |
| AutoFilterMode | ChartObjects | BeforeRightClick |
| Cells | CheckSpelling | Calculate |
| CircularReference | CircleInvalid | Change |
| CodeName | ClearArrows | Deactivate |
| Columns | Copy | FollowHyperlink |
| EnableSelection | Delete | PivotTableUpdate |
| Hyperlinks | Evaluate | SelectionChange |
| Name | Move | |
| ProtectContents | OLEObjects | |
| Protection | Paste | |
| ProtectScenarios | PasteSpecial | |
| Range | PivotTables | |
| Rows | PivotTablesWizard | |
| ScrollArea | SaveAs | |
| Type | Select | |
| Visible | Unprotect |
| 属性 | 方法 | 方法 |
| AddIndent | Activate | |
| Address | AddComment | FillUp |
| AddressLocal | AdvancedFilter | Find |
| AllowEdit | ApplyNames | FindNext |
| Application | ApplyOutlineStyles | FindPrevious |
| Areas | AutoComplete | FunctionWizard |
| Borders | AutoFill | GoalSeek |
| Cells | AutoFilter | Group |
| Characters | AutoFit | Insert |
| Column | AutoFormat | Justify |
| Columns | AutoOutline | Merge |
| ColumnWidth | BorderAround | NavigateArrow |
| Comment | Calculate | NoteText |
| Count | CheckSpelling | Parse |
| Creator | Clear | PasteSpecial |
| CurrentArray | ClearComments | PrintOut |
| CurrentRegion | ClearContents | PrintPreview |
| Dependents | ClearFormats | RemoveSubtotal |
| DirectDependents | ClearNotes | Replace |
| Font | ClearOutline | RowDifference |
| FormatConditions | ClearDifferences | Run |
| Formula | Consolidate | Select |
| FormulaArray | Copy | SetPhonetic |
| FormulaHidden | CopyFromRecordset | Show |
| FormulaLabel | CopyPicture | ShowDependents |
| FormulaLocal | CreateNames | ShowErrors |
| FormulaR1C1 | CreatePublisher | ShowPrecedents |
| FormulaR1C1Local | Cut | Sort |
| Height | DataSeries | SortSpecial |
| Name | Delete | Speak |
| Value | DialogBox | SpecialCells |
| Text | Dirty | SubscribeTo |
| Row | EditionOptions | Subtotal |
| Rows | FillDown | Table |
| Range | FillLeft | TextToColumns |
| RowHeight | FillRight | UnMerge |
【Excel&VBA】VBA对象体系
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。