Excel Experts, Can you help with Excel Speech?

Question

When I enter data in cell ref:A1 and press <enter>, I need to computer to speak whatever word appears in cell reference E1.

For example,

I type “11841” in cell a1 and press <enter> and the computer reads out the word “apple” in cell ref E1.

I have about 500 different numbers to type in A1 which all change the word in E1, for each entry in cell a1 I need it to speak the contents of E1 every time <enter> is pressed.

Can this be done?

garbo7441 · Accepted Answer

You will have to use a VBA event handler to invoke the Speak function upon change of value in cell A1.  Here is one way to do that.  This example assumes that your number/word combinations function as you have stated in your question, i.e. cell E1 changes upon a change of value in A1.

Copy this event handler to the clipboard (highlight the entire event handler, right click inside the highlighted area, and 'Copy'):

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(0, 0) = "A1" Then
sayWhat = Range("E1").Value
Application.Speech.Speak (sayWhat)
End If
End Sub

Select the worksheet that contains the cell you wish to 'speak' and right click the sheet tab at the bottom.

Select 'View Code'.

Paste the event handler into the white editing area to the right (right click inside the area and 'Paste').

Close the VBE (red button - top right).

Save the workbook as an Excel Macro-Enabled Workbook in order to retain the Speak functionality when you open the workbook in the future,

Enter a code number in A1 and press ENTER, TAB, or select any other cell with your mouse.  The content of cell E1 will be audible.

Note:  this function is available beginning with Excel 2007.

☆☆♥☆☆ ☆αℓℓ☆ ☆gσσ∂☆ ☆Thiηgs☆☆ · Answer

F'in brilliant Gold Star*

Anonymous · Answer

Yes, use VLOOKUP. Read the Excel helpfile for details and examples.

Trending News

Excel Experts, Can you help with Excel Speech?

3 Answers