SpeakCellOnEnter Property

Microsoft Excel Visual Basic

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."
    End If

End Sub