Partager via


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.

Syntax

expression .Direction

expression A variable that represents a Speech object.

Remarks

XlSpeakDirection can be one of these XlSpeakDirection constants.

xlSpeakByColumns

xlSpeakByRows

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

See Also

Concepts

Databar Object Members

Databar Object

Speech Object

Speech Object Members