A talking worksheet

The SayIt function uses Excel's text-to-speech generator to "speak" it's argument (which can be literal text or a cell reference).

Function SayIt(txt)

Application.Speech.Speak (txt) SayIt = txt End Function

This function has some amusement possibilities, but it can also be useful. For example, use the function in a formula like this:

=IF(SUM(A:A)>25000,SayIt("Goal Reached"))

If the sum of the values in column A exceeds 25,000, you'll hear the synthesized voice tell you that the goal has been reached. You can also use the Speak method at the end of a lengthy procedure. That way, you can do something else and you'll get an audible notice when the procedure ends.

0 0

Post a comment