Application.GetPhonetic method (Excel)

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 A variable that represents an Application object.


Name Required/Optional Data type Description
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.

Return value



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

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.