Class Phonetic (Excel VBA)

Contains information about a specific phonetic text string in a cell.

Class Range gives access to class Phonetic.

Member in collection

Item

To use a Phonetic class variable it first needs to be instantiated, for example

Dim phn as Phonetic
Set phn = ActiveCell.Phonetic

The following procedures can be used to set variables of type Phonetic: Phonetics.Item and Range.Phonetic.

For Each

Here is an example of processing the Phonetic items in a collection.

Dim phn As Phonetic
For Each phn In Application.Phonetics
	
Next phn

Phonetics.Add - Adds phonetic text to the specified cell.

Phonetics.Delete - Deletes the object.

Properties

Phonetics.Item (Default member) - Returns a single object from a collection.

Alignment returns or sets a Long value that represents the alignment for the specified phonetic text or tick label.

CharacterType returns or sets the type of phonetic text in the specified cell.

Font returns a Font object that represents the font of the specified object.

Text returns or sets the text for the specified object.

Visible returns or sets a Boolean value that determines whether the object is visible.

Phonetics.Alignment returns or sets a Long value that represents the alignment for the specified phonetic text or tick label.

Phonetics.CharacterType returns or sets the type of phonetic text in the specified cell.

Phonetics.Count returns a Long value that represents the number of objects in the collection.

Phonetics.Font returns a Font object that represents the font of the specified object.

Phonetics.Length returns a Long value that represents the number of characters of phonetic text from the position you've specified with the Start property.

Phonetics.Start returns the position that represents the first character of a phonetic text string in the specified cell.

Phonetics.Text returns or sets the text for the specified object.

Phonetics.Visible returns or sets a Boolean value that determines whether the object is visible.

Font - Contains the font attributes (font name, font size, color, and so on) for an object.