Skip to Main Content
Writing Excel Macros with VBA, 2nd Edition
book

Writing Excel Macros with VBA, 2nd Edition

by Steven Roman PhD
June 2002
Beginner content levelBeginner
570 pages
16h 48m
English
O'Reilly Media, Inc.
Content preview from Writing Excel Macros with VBA, 2nd Edition

Name

Speech Object

Synopsis

Path: Application - Speech

Object

Methods

Properties

Speech

  • Speak(Text As String, [SpeakAsync] As Variant, [SpeakXML] As Variant, [Purge] As Variant)

  • Direction( ) As XlSpeakDirection

  • SpeakCellOnEnter( ) As Boolean

The Speech object is a very simple object that is used to implement speech in Excel XP. To obtain a Speech object, use the Speech property of the Application object. The Speech object has only two properties, Direction and SpeakCellOnEnter, and one method, Speak.

The Direction property sets the speech direction to one of the constants in the following enum:

Enum XlSpeakDirection
	xlSpeakByRows = 0
	xlSpeakByColumns = 1
End Enum

This sets the speech direction when using the Speak property of the Range object. For instance, if the activesheet has content:

A1 = 1, B1 = 2
A2 = 3, B2 = 4

Then the code:

Range("A1:B2").Speak xlSpeakByRows

will speak “1, 2, 3, 4”

whereas the code:

Range("A1:B2").Speak xlSpeakByColumns

will speak “1, 3, 2, 4”

The SpeakCellOnEnter property is a Boolean property that specifies whether or not Excel will speak the contents of the active cell when the Enter key is struck or when the focus moves to another cell after editing of that cell. (The cell contents are not spoken just because focus is lost—it only happens when the cell has been edited and focus is lost.)

The Speak method speaks text, as in:

Application.Speech.Speak "To be or not to be"

or:

Application.Speech.Speak ActiveSheet.Range("A1").Value
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft Excel 2019 VBA and Macros, First Edition

Microsoft Excel 2019 VBA and Macros, First Edition

Bill Jelen, Tracy Syrstad
VBA and Macros for Microsoft Excel

VBA and Macros for Microsoft Excel

Bill Jelen, Tracy Syrstad
Excel 2016 VBA and Macros

Excel 2016 VBA and Macros

Bill Jelen, Tracy Syrstad

Publisher Resources

ISBN: 0596003595Supplemental ContentErrata Page