View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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