Jun 22 2018 06:28 AM
I know how to make excel speak my cells, so I can listen to it. However, I want to be able to type data in a different program at the same time while it is playing. Is that possible?
Jun 22 2018 06:39 AM
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.
Jun 22 2018 07:12 AM
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
Jun 22 2018 07:17 AM
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.
Jun 22 2018 07:33 AM
Actually, I'm having issues again. Everytime I click out of excel it stops speaking. Any ideas what I'm doing wrong?
Jun 22 2018 08:28 AM