Phonetic Property [Excel 2003 VBA Language Reference]

  • Article

Returns the Phonetic object, which contains information about a specific phonetic text string in a cell.

Remarks

This property provides compatibility with earlier versions of Microsoft Excel. You should use Phonetics(index), where index is the index number of the phonetic text, to return a single Phonetic object.

For information about using phonetic worksheet functions in Microsoft Visual Basic, see Using Microsoft Excel Worksheet Functions in Visual Basic .

Example

This example sets the first phonetic text string in the active cell to "furiganafuriganafuriganafurigana".

ActiveCell.Phonetics(1).Text = ""

To demonstrate compatibility with earlier versions of Microsoft Excel, this example hides the Furigana characters in cell C5.

Range("C5").Phonetic.Visible = False

Applies to | Range Collection