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:
Post a Comment