Редагувати

Поділитися через

Speech.SpeakCellOnEnter property (Excel)

  • Стаття

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

Syntax

expression.SpeakCellOnEnter

expression A variable that represents a Speech object.

Example

This example determines if the active cell is spoken when the Enter key is pressed or the active cell is finished 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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.