Speech.Direction Property (Excel)

Returns or sets the order in which the cells will be spoken. The value of the Direction property is an XlSpeakDirection constant. Read/write.

expression .Direction

expression A variable that represents a Speech object.

XlSpeakDirection can be one of these XlSpeakDirection constants.

xlSpeakByColumns

xlSpeakByRows

In this example, Microsoft Excel determines the speech direction and notifies the user.

Sub CheckSpeechDirection() 
 
 ' Notify user of speech direction. 
 If Application.Speech.Direction = xlSpeakByColumns Then 
 MsgBox "The speech direction is set to speak by columns." 
 Else 
 MsgBox "The speech direction is set to speak by rows." 
 End If 
 
End Sub
Show:
© 2015 Microsoft