Can you use Excel’s text-to-speech functionality in VBA? You bet. Simply use this line of code: application.speech.speak and then specify your text in paranthesis or you can even use a variable. If your variable was called Announcement, your code would look like this:
application.speech.speak announcement
And to read text:
application.speech.speak (”This is the text!”)
Simple!
Jared Hawk is a professional Excel Seminar Trainer and Consultant in Boise, ID. He is also a contributing author to www.masterthebusiness.com.