Make a macro to have curcusor cell talk

[GoodmanJim]

When giving a talk using excel, I would like to have the computer speak the written words.
Place the cursor on the cell and press alt plus j

 

[Micron]

AFAIK, you must use Ctrl key plus a letter. In its simplest form, you could create a standard module and enter this into it:

Public Sub SpeakIt()
Application.Speech.Speak ActiveCell
End Sub

Then on developer tab, choose that macro, click options and assign a letter key to the Ctrl+ option. What's not great about that is you may end up choosing a combination that is already assigned. Another option is to use one of the sheet click events, or selection change event to trigger code. In any case, the result may or may not be spoken as you wish (e.g. 123-456 will say "one hundred and twenty three to four hundred and fifty six)

 

[GoodmanJim]

Thank you it works grear

 

[Micron]

Glad I could help. It's customary to mark your thread as solved when you have a solution so that others who are looking for unsolved threads don't open yours.