New Excel Forum

This forum has been moved to TeachExcel.

Ask all future questions in the new excel forum.

ExcelKey

Make Excel talk with Application.Speech.speak

Free Excel Tips and Tutorials
Forum rules
This forum is closed.

All new posts should be made at our new Excel Forum at TeachExcel.com.

Make Excel talk with Application.Speech.speak

Postby Apcbr » Sun Apr 29, 2012 8:26 pm

A nice feature in Excel.

With Application.Speech.speak you can have Excel talk to you.
Either use direct input or values from a cell.

Code: Select all
    Private Sub Workbook_Open()
    Application.Speech.Speak ("Welcome to this work book")
    End Sub


or to speak text from the active cell
Code: Select all
    Sub CommandButton_Click()
    Application.Speech.Speak Activecell
    End Sub
Greetings,
Apcbr

Say what you mean, mean what you say :-)
Apcbr
Regular
 
Posts: 38
Joined: Apr 25, 2012
Reputation: 0
Excel Version: 2007

Return to Excel Tips and Tutorials

Who is online

Users browsing this forum: No registered users and 1 guest