Forum Discussion
Solved
Setting IF function to speak a sentence
Hi everyone. I am trying, with no success, set an IF command, through VBA, to speak a pre set sentence if a pre defined condition is reached. Example: =IF("A1>100";"Congratulation!! You reached y...
No problem, please test it as per your convenience and let me know if that works for you as desired.
Honestly, in my opinion, forcing the macro to speak out several sentences in one go would be like overuse of this feature. Why not add some visuals on the sheet once one or more criteria are met?
Actually I thought it as well but a "voice alert" would work better. However I undertand your point. There is another solution do make the macro's work lighter: split my worksheet in several different sheets, each one with its own macro. Well, I do not know. Let me see how hard it would be to decide which way I will take. Anyway, I don't want to push you with this demand. Thanks a lot Subodh_Tiwari_sktneer for your valuable help. I will keep trying.