Microsoft Office Tutorials and References
In Depth Information
Appendix G. New Objects in Excel XP
Orientation() As Variant
ShrinkToFit() As Variant
VerticalAlignment() As Variant
WrapText() As Variant
The CellFormat object works in conjunction with the FindFormat and ReplaceFormat objects to
programmatically find and replace cell formatting. For more on this, please see Chapter 16 .
CustomProperty Object
Path: Application -- Range -- Worksheet --
CustomProperties - CustomProperty
Object
Methods
Properties
Name() As String
Value() As Variant
Delete()
CustomProperty
Count() As Long
Item(Index As Variant) As
CustomProperty
Add(Name As String, Value As
Variant) As CustomProperty
CustomProperties
The Microsoft documentation, with its usual obscurity, states the following about the
CustomProperty object: "Represents identifier information. Identifier information can be used as
metadata for XML." However, the documentation does not bother to elaborate on how this
information can be used as metadata. In any case, it is not our intention in this topic to cover the
XML-related features of Excel.
The CustomProperties collection holds CustomProperty objects.
Diagram, DiagramNode and DiagramNodeChildren Objects
Path: Application -- Chart -- Shapes -- Shape -
Diagram -- DiagramNodes --
Diagram-Node-DiagramNodeChildren
Object
Methods
Properties
AutoFormat() As
MsoTriState
AutoLayout() As
MsoTriState
Nodes() As
DiagramNodes
Reverse() As
MsoTriState
Type() As
Convert(Type As MsoDiagramType)
Diagram
Search JabSto ::




Custom Search