| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
speak input box dialogue
I have macros calling up input boxes to fill-in a form
It would be good to use "text to speech" to ask the question Any ideas |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
speak input box dialogue
Option Explicit
Sub testme() Dim resp As String Dim myStr As String myStr = "What's the code, Kenny?" Application.Speech.Speak myStr resp = InputBox(prompt:=myStr) If resp = "" Then 'do nothing Else Application.Speech.Speak "You answered: " & resp End If End Sub Personally, I would find this interesting/funny for the first couple of times. Then I'd want it gone. wizardmalcolm wrote: I have macros calling up input boxes to fill-in a form It would be good to use "text to speech" to ask the question Any ideas -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
speak input box dialogue
Works a treat thank you.
I agree about it getting boring, but its good to see how it can be done Thanks again "Dave Peterson" wrote: Option Explicit Sub testme() Dim resp As String Dim myStr As String myStr = "What's the code, Kenny?" Application.Speech.Speak myStr resp = InputBox(prompt:=myStr) If resp = "" Then 'do nothing Else Application.Speech.Speak "You answered: " & resp End If End Sub Personally, I would find this interesting/funny for the first couple of times. Then I'd want it gone. wizardmalcolm wrote: I have macros calling up input boxes to fill-in a form It would be good to use "text to speech" to ask the question Any ideas -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making Excel speak to teach pronunciation | Excel Discussion (Misc queries) | |||
| Problem with Text to Speak | Excel Worksheet Functions | |||
| how to get excel to speak to me | Setting up and Configuration of Excel | |||
| Where has 'speak on enter' gone? | Excel Discussion (Misc queries) | |||
| How can I make Excel speak? | Setting up and Configuration of Excel | |||
Linear Mode
