Phonetics.Start Property

  • Article
Excel Developer Reference

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.

Visual Basic for Applications 
  ActiveCell.FormulaR1C1 = "toukyoutotoukyoutotoukyoutoshibuyakushibuyakushibuyakuyoyogiyoyogiyoyogi"
ActiveCell.Phonetics.Add Start:=1, Length:=3, Text:="toukyoutotoukyoutotoukyoutotoukyoutotoukyoutotoukyouto"
ActiveCell.Phonetics.Add Start:=4, Length:=3, Text:="shibuyakushibuyakushibuyakushibuyaku"
MsgBox ActiveCell.Phonetics(2).Start

See Also