SpeakCellOnEnter Property

Microsoft Excel Visual Basic

SpeakCellOnEnter Property

       

Microsoft Excel supports a mode where the active cell will be spoken when the ENTER key is pressed or when the active cell is finished being edited.  Setting the SpeakCellOnEnter property to True will turn this mode on.  False turns this mode off. Read/write Boolean.

expression.SpeakCellOnEnter

expression   Required. An expression that returns a Speech object.

Example

This example determines if the active cell will be spoken when the ENTER key is pressed or the active cell is done being edited, and notifies the user.

Sub SpeechCheck()

    ' Determine mode setting and notify user.
    If Application.Speech.SpeakCellOnEnter = True Then
        MsgBox "The Speak On Enter mode is turned on. " & _
            "The active cell will be spoken when the ENTER "& _
            "key is pressed or it is done being edited."
    Else
        MsgBox "The Speaker On Enter mode is turned off."
    EndIf

End Sub