VBA: Speak to Me
Do you have a newer edition of Excel with “Text to Speech” installed? If so, you can make Excel speak from VBA code. Don’t forget to turn up your speakers.
The following will speak the text in cell A1 of the ActiveSheet:
Sub SayThisCell() Cells(1, 1).Speak End Sub
This Macro doesn’t require text to be in any spreadsheet, it speaks the contents of a string:
Sub SayThisString() Dim SayThis As String SayThis = "I love Microsoft Excel" Application.Speech.Speak (SayThis) End Sub
Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
Get answers right away at our AE Excel Support Forums!



I had found this code in a book once and wanted to use it now, so your site is exactly what I was looking for. Thanks!