Forum Discussion

Caitlin Smith's avatar
Caitlin Smith
Copper Contributor
Jun 22, 2018

Excel Speak Cells

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?

excel

6 Replies

Sort By
  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor
    Jun 22, 2018

    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 Smith's avatar
      Caitlin Smith
      Copper Contributor
      Jun 22, 2018

      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 Mickle's avatar
        Matt Mickle
        Bronze Contributor
        Jun 22, 2018

        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.

Resources