Excel VBA教程:新的属性(按对象排序)

在 Microsoft Excel 2002 中,为现有对象添加了许多新的 Visual Basic for Applications属性。下表列出了这些属性(按对象名称排序)。

对象属性
AddIn
CLSID
AllowEditRange
Users
Application
AutoFormatAsYouTypeReplaceHyperlinks
AutomationSecurity
AutoRecover
CalculationInterruptKey
CalculationState
DecimalSeparator
DisplayFunctionToolTips
DisplayInsertOptions
DisplayPasteOptions
ErrorCheckingOptions
FileDialog
FindFormat
GenerateGetPivotData
Hinstance
Hwnd
MapPaperSize
NewWorkbook
Ready
ReplaceFormat
RTD
ShowStartupDialog
SmartTagRecognizers
Speech
SpellingOptions
ThisCell
ThousandsSeparator
UsedObjects
UseSystemSeparators
Watches
AutoCorrect
DisplayAutoCorrectOptions
AutoRecover
Time
CalculatedMember
IsValid
SolveOrder
Chart
MailEnvelope
Tab
ColorFormat
Black
Cyan
Ink
Magenta
OverPrint
TintAndShade
Yellow
CubeField
EnableMultiplePageItems
HasMemberProperties
ShowInFieldList
DataLabel
Separator
ShowBubbleSize
ShowCategoryName
ShowPercentage
ShowSeriesName
ShowValue
DataLabels
Separator
ShowBubbleSize
ShowCategoryName
ShowPercentage
ShowSeriesName
ShowValue
DefaultWebOptions
SaveNewWebPagesAsWebArchives
TargetBrowser
Diagram
AutoFormat
AutoLayout
Reverse
DiagramNode
Children
Diagram
Layout
Root
TextShape
DiagramNodeChildren
FirstChild
LastChild
Error
Ignore
ErrorCheckingOptions
BackgroundChecking
EmptyCellReferences
EvaluateToError
InconsistentFormula
IndicatorColorIndex
NumberAsText
OmittedCells
TextDate
UnlockedFormulaCells
IRTDUpdateEvent
HeartbeatInterval
PageSetup
CenterFooterPicture
CenterHeaderPicture
LeftFooterPicture
LeftHeaderPicture
PrintErrors
RightFooterPicture
RightHeaderPicture
PivotCache
ADOConnection
IsConnected
MissingItemsLimit
OLAP
RobustConnect
SourceConnectionFile
SourceDataFile
PivotCell
ColumnItems
CustomSubtotalFunction
DataField
PivotCellType
RowItems
PivotField
CurrentPageList
DatabaseSort
EnableItemSelection
HiddenItemsList
IsMemberProperty
PropertyOrder
PropertyParentField
StandardFormula
PivotFormula
StandardFormula
PivotItem
SourceNameStandard
StandardFormula
PivotTable
CalculatedMembers
DataPivotField
DisplayEmptyColumn
DisplayEmptyRow
DisplayImmediateItems
EnableDataValueEditing
EnableFieldList
MDX
PivotSelectionStandard
ShowCellBackgroundFromOLAP
ShowPageMultipleItemLabel
ViewCalculatedMembers
VisualTotals
Protection
AllowDeletingColumns
AllowDeletingRows
AllowEditRanges
AllowFiltering
AllowFormattingCells
AllowFormattingColumns
AllowFormattingRows
AllowInsertingColumns
AllowInsertingHyperlinks
AllowInsertingRows
AllowSorting
AllowUsingPivotTables
PublishObject
AutoRepublish
QueryTable
EditWebPage
RobustConnect
SourceConnectionFile
SourceDataFile
TextFileTrailingMinusNumbers
WebDisableRedirections
Range
AllowEdit
Errors
PivotCell
SmartTags
RTD
ThrottleInterval
Shape
Child
Diagram
DiagramNode
HasDiagram
HasDiagramNode
ParentGroup
ShapeRange
Child
Diagram
DiagramNode
HasDiagram
HasDiagramNode
ParentGroup
SmartTag
DownloadURL
Properties
SmartTagActions
XML
SmartTagOptions
DisplaySmartTags
EmbedSmartTags
SmartTagRecognizers
Recognize
Speech
Direction
SpeakCellOnEnter
SpellingOptions
ArabicModes
DictLang
GermanPostReform
HebrewModes
IgnoreCaps
IgnoreFileNames
IgnoreMixedDigits
KoreanCombineAux
KoreanProcessCompound
KoreanUseAutoChangeList
SuggestMainOnly
UserDict
UserAccess
AllowEdit
WebOptions
TargetBrowser
Workbook
EnableAutoRecover
FullNameURLEncoded
Password
PasswordEncryptionAlgorithm
PasswordEncryptionFileProperties
PasswordEncryptionKeyLength
PasswordEncryptionProvider
RemovePersonalInformation
ShowPivotTableFieldList
SmartTagOptions
UpdateLinks
WritePassword
Worksheet
CustomProperties
MailEnvelope
Protection
SmartTags
Tab

上页:Excel VBA教程:新的属性(按字母顺序列出) 下页:Excel VBA教程:为 Microsoft Excel 2002 开发人员提供的新增功能

Excel VBA教程:新的属性(按对象排序)

Excel VBA教程:为 Microsoft Excel 2002 开发人员提供的新增功能 Excel VBA教程:OLE 程序标识符
Excel VBA教程:AcceptAllChanges方法 Excel VBA教程:Activate方法
Excel VBA教程:ActivateMicrosoftApp方法 Excel VBA教程:ActivateNext方法
Excel VBA教程:ActivatePrevious方法 Excel VBA教程:Add方法
Excel VBA教程:AddCallout方法 Excel VBA教程:AddChartAutoFormat方法
Excel VBA教程:AddComment方法 Excel VBA教程:AddConnector方法
Excel VBA教程:AddCurve方法 Excel VBA教程:AddCustomList方法
Excel VBA教程:AddDataField方法 Excel VBA教程:AddDiagram方法
Excel VBA教程:AddFields方法 Excel VBA教程:AddFormControl方法
Excel VBA教程:AddItem方法 Excel VBA教程:AddLabel方法
版权所有 © 中山市飞娥软件工作室 证书:粤ICP备09170368号