Search This Blog

Monday 12 December 2011

Can Excel Speak? Yes It Can!!!

Hi Guys,

Today I will show you how to create a function to make your Excel read texts.

The function is the following:

'######################################################################

'Author Paolo Succo
'Date 12 December 2011

'Function to make your spreadsheet red texts

'######################################################################

Function Talk(txt)

Application.Speech.Speak (txt)
Talk = txt

End Function

After creating a VBA module with this VBA code, you will beallow to use a new Excel formula called "Talk".
Write your text in any cell in your spreadsheet and make the formula read the text.

E.g.

Write the text in A1 and enter in B1 the formula =Talk(A1)

I hope you enjoy!

No comments: