Direction Property

Microsoft Excel Visual Basic

Show All

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