Range.Phonetics Property

Excel Developer Reference

Returns the Phonetics collection of the range. Read only.

Syntax

expression.Phonetics

expression   A variable that represents a Range object.

Example

This example displays all of the Phonetic objects in the active cell.

Visual Basic for Applications
  Set objPhon = ActiveCell.Phonetics
With objPhon
    For Each objPhonItem in objPhon
        MsgBox "Phonetic object: " & .Text
    Next
End With

See Also