Writing Excel Macros with VBA, 2nd Edition

Name

CustomProperty Object

Synopsis

Path: Application  --  Range  --  Worksheet  --  CustomProperties - CustomProperty
               

Object	Methods	Properties
CustomProperty	Delete( )	Name( ) As String Value( ) As Variant
CustomProperties	Add(Name As String, Value As Variant) As CustomProperty	Count( ) As Long Item(Index As Variant) As CustomProperty

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 book to cover the XML-related features of Excel.

The CustomProperties collection holds CustomProperty objects.