67
Phonetics Collection Properties and Methods
Name
Returns
Description
Alignment
Long
Set/Get the alignment for the phonetic text. Use the
XlPhoneticAlignmentconstants
CharacterType
Long
Set/Get the type of phonetic text to use. Use the
XLPhoneticCharacterTypeconstants
Font
Font
Read-only. Returns an object containing Fontoptions for
the text in the Phoneticscollection
Length
Long
Read-only. Returns the number of phonetic text characters
starting from the Startparameter
Start
Long
Read-only. Returns the position that represents the first
character of the phonetic text strings. Valid only if there is
only one Phoneticobject in the collection
Text
String
Set/Get the phonetic text. Valid only if there is only one
Phoneticobject in the collection
Visible
Boolean
Set/Get whether the phonetic text is visible to the end
user. Valid only if there is only one Phoneticobject in the
collection
Add
Method. Parameters: StartAsLong, LengthAsLong,
TextAsString. Adds a Phoneticobject to the collec-
tion at the cell specified by the parent Rangeobject
Delete
Method. Deletes all the Phoneticobjects in the collection
Phonetic Common Properties
The Application, Creator, and Parentproperties are defined at the beginning of this appendix.
Phonetic Properties
Name
Returns
Description
Alignment
Long
Set/Get the alignment for the phonetic text. Use the
XlPhoneticAlignmentconstants
CharacterType
Long
Set/Get the type of phonetic text to use. Use the
XLPhoneticCharacterTypeconstants
Font
Font
Read-only. Returns an object containing Fontoptions for
the phonetic text
Text
String
Set/Get the phonetic text
Visible
Boolean
Set/Get whether the phonetic text is visible to the end
user
805
Phonetics Collection Properties and Methods