Phonetics Collection Object [Excel 2003 VBA Language Reference]
Range Phonetics Font |
A collection of all the Phonetic objects in the specified range. Each Phonetic object contains information about a specific phonetic text string.
Using the Phonetics Collection
Use the Phonetics property to return the Phonetics collection. The following example makes all phonetic text in the range A1:C4 visible.
Range("A1:C4").Phonetics.Visible = True
Use Phonetics(index), where index is the index number of the phonetic text, to return a single Phonetic object. The following example sets the first phonetic text string in the active cell to "".
ActiveCell.Phonetics(1).Text = ""
Properties | Alignment Property | Application Property | CharacterType Property | Count Property | Creator Property | Font Property | Item Property | Length Property | Parent Property | Start Property | Text Property | Visible Property
Methods | Add Method | Delete Method
Parent Objects | Range Collection
Child Objects | Font Object