Function Speak(c As Boolean, s As String)
If c Then Application.Speech.Speak s
Speak = c
End Function
This function speaks when used for lets say a1>a2, then speak b1, then we write =speak(a1>a2,b1)
now my problem is every time a1 will change and becomes greater than a2, it will speak b1. I want to make sure that it repeats b1 at least after 30 seconds. (or the time which i'll mention).
Can some one suggest me, how can application.ontime help me do this.
I've used application.ontime for macros, but not for defined function.
with regards
Anup
If c Then Application.Speech.Speak s
Speak = c
End Function
This function speaks when used for lets say a1>a2, then speak b1, then we write =speak(a1>a2,b1)
now my problem is every time a1 will change and becomes greater than a2, it will speak b1. I want to make sure that it repeats b1 at least after 30 seconds. (or the time which i'll mention).
Can some one suggest me, how can application.ontime help me do this.
I've used application.ontime for macros, but not for defined function.
with regards
Anup