Excel Text-to-Speech

[msgb1080]

I am fairly new to VBA, and I have a project for a class I am working on.

Our professor wants us to use the text-to speech function in Excel to have the computer read the instructions for our User Forms. The code I am using now is:

Private Sub cmdListen_Click()
Application.Speech.Speak (”Hello”)
End Sub

This is not working. Any suggestions?

 

[Dryver14]

Private Sub cmdListen_Click()
Application.Speech.Speak "Hello"
End Sub

 

[msgb1080]

Just tried that. I'm still getting Compile error: Variable not defined

When I deleted Option Explicit I didn't get the error anymore, but no sound comes out when I click on the command button.

 

[Dryver14]

to be honest I have never used cmdlisten.click and dont know what it does, I just tried it using F5 in the module.

If you have a command button then maybe you should be using commandbutton.click

 

[msgb1080]

My command button is named cmdListen, so cmdListen.click is just the button's click event.

Thanks for the help though!!

 

[Dryver14]

OK, when I first used your code without the brackets it did not work as your appostrophies were somehow wrong, when I deleted them and used mine from shift+2 it worked, did you copy my code or rewrite it?

 

[msgb1080]

Thanks!! I copied the original code from Excels Help menu. I changed the " and it works fine!!

 

[Dryver14]

Glad to have helped