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.
- Caitlin SmithJun 22, 2018Copper Contributor
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
- Matt MickleJun 22, 2018Bronze Contributor
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.
- Caitlin SmithJun 22, 2018Copper Contributor
Actually, I'm having issues again. Everytime I click out of excel it stops speaking. Any ideas what I'm doing wrong?