Edit

Share via

Phonetics.Start property (Excel)

  • Article

Returns the position that represents the first character of a phonetic text string in the specified cell. Read-only Long.

Syntax

expression.Start

expression A variable that represents a Phonetics object.

Example

This example returns the starting position 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).Start

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.