Phonetics.Length Property

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

Syntax

expression.Length

expression   A variable that represents a Phonetics object.

Example

This example returns the length of the second phonetic text string in the active cell.

  ActiveCell.FormulaR1C1 = ""
ActiveCell.Phonetics.Add Start:=1, Length:=3, Text:=""
ActiveCell.Phonetics.Add Start:=4, Length:=3, Text:=""
MsgBox ActiveCell.Phonetics(2).Length

See Also

• Phonetics Object
• Phonetics Object Members