Forum Discussion
mctribeiro
Sep 04, 2019Copper Contributor
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...
- Sep 05, 2019
No problem, please test it as per your convenience and let me know if that works for you as desired.
mctribeiro
Sep 05, 2019Copper Contributor
Hello my friend.
Thanks a lot for your quick response. The A1 cell is a result of other cells caculation, as your first assumption. I will test your command through your sheet example tomorrow and let you know the result. Thank you very much one more time.
Thanks a lot for your quick response. The A1 cell is a result of other cells caculation, as your first assumption. I will test your command through your sheet example tomorrow and let you know the result. Thank you very much one more time.
Subodh_Tiwari_sktneer
Sep 05, 2019Silver Contributor
No problem, please test it as per your convenience and let me know if that works for you as desired.
- DebubAug 25, 2021Copper ContributorHi Sir,
I found that you have described how to use if function with speak cell I did it but one problem arises. Problem is the other cells are also speaking the same command even when the other cells value are different . Is it possible for you to resolve this problem as I want other cell not to speak.
Regards,
Debjit - mctribeiroSep 05, 2019Copper ContributorYou are a very nice person. Thank you so much.
- Subodh_Tiwari_sktneerSep 05, 2019Silver Contributor
- mctribeiroSep 07, 2019Copper Contributor
Hi Subodh_Tiwari_sktneer . As I am new in this forum how do I mark in my post it has been solved?