top of page

Let Excel Speak to You Like Siri

Updated: Nov 9, 2019

Many of us are familiar with Siri. It's a robot which can talk with you. Excel is not that intelligent to interact with you like Siri at this moment. But with Excel VBA, you can let Excel say something to you under certain circumstances. Let's see how it works.

"The future belongs to those who believe in the beauty of their dreams." - Eleanor Roosevelt

Sometimes when you save an Excel workbook, you will get one message to tell you the file already exists. This is actually done by the MsgBox function. Now let's ask Excel to say that sentence to you.

First of all, you need use open the built-in Visual Basic for Applications editor. Then go to Tools and open the VBA Project References dialogue box. Make sure the box in front of "Microsoft Speech Object Library" is checked.

Then type the below codes in the Code Pane.

Sub Speak()

Application.Speech.Speak ("The file already exists!")

End Sub

Alright. Here we go. Just click the green Run button on the tools bar or press F5 to run the codes. Have you heard the voice from your computer? If not, probably it was muted. Unmute it and try it again.

You may use the speak function in your own VBA projects. Customize it and make your application stylish.

79 views0 comments

Recent Posts

See All
bottom of page