Share via

SpeakCellOnEnter Property [Excel 2003 VBA Language Reference]

  • Article

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

End Sub

Applies to | Speech Object