Forum Discussion
Excel Speak Cells
Hey Caitlin-
Hope you're doing well. I can see some application for having Excel dictate cell values while you type in another program. When I tested this out with word. I was able to type in word while Excel read my cell values. Is this something like what you want? If so the below worked for me.
Sub Test()
'Speak values in cells A2 to A10 in 5 second intervals
For x = 2 To 10
With Application
.Speech.Speak Range("A" & x) 'Speak the cell value
.Wait (Now + TimeValue("0:00:05")) 'Wait 5 seconds to have time to type what Excel dicatates
End With
Next
End Sub
If not, it sounds like you may be using some sort of screen reader. I'm not familiar with this technology so I'll have to defer in this case.
I am using a double monitor if that makes a difference. I am trying to type values into an internet program on one computer while the other computer reads the excel values. Is that possible?
Thanks
Hey Caitlin-
I have two monitors in my environment as well. It seems to work perfectly fine for me. I am actually typing in this internet form while testing right now. No issues. Still reading them aloud.
Actually, I'm having issues again. Everytime I click out of excel it stops speaking. Any ideas what I'm doing wrong?
- Hey Caitlin-
Unfortunately, I'm not really sure. I can click in and out of Excel into Chrome without issue. Can you provide more information on your scenario, perhaps another community member will be able to help out or the below information may make something stick out.
Some relevant items may be:
Windows Version:
Excel Version:
VBA Code you are using:
Mockup Workbook Data to assist with testing:
Web Browser:
Web Application/URL:
I think I figured it out. Thank you!!!