GetPhonetic Method

Microsoft Excel Visual Basic

Returns the Japanese phonetic text of the specified text string. This method is available to you only if you have selected or installed Japanese language support for Microsoft Office.

expression.GetPhonetic(Text)

expression    An expression that returns an Application object.

Text    Optional Variant. Specifies the text to be converted to phonetic text. If you omit this argument, the next possible phonetic text string (if any) of the previously specified Text is returned. If there are no more possible phonetic text strings, an empty string is returned.

Example

This example displays all of the possible phonetic text strings from the specified string.

strPhoText = Application.GetPhonetic("junkojunko")
While strPhoText <> ""
    MsgBox strPhoText
    strPhoText = Application.GetPhonetic()
Wend