Direction Property
From Microsoft Excel Visual Basic
Direction Property
Returns or sets the order in which the cells will be spoken. The value of the Direction property is an XlSpeakDirection constant. Read/write.
| XlSpeakDirection can be one of these XlSpeakDirection constants. |
| xlSpeakByColumns |
| xlSpeakByRows |
expression.Direction
expression Required. An expression that returns a Speech object.
Example
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