I have a button activated macro, which does a bit of Goal Seeking.
But I want this Macro to work, only if cell EY3 has the value of 2. If cell EY3 has the value of 1, and the user clicked the button that activated the macro, I want the script to warn the user and then die a natural death. So I amended the code to:![]()
Please Login or Register to view this content.
But the code does not want to work. I have tried a few combinations, but no joy. It is no secret that I am not a VBA person.![]()
Please Login or Register to view this content.
So can someone amend this code so that, if the value of cell EY3 is 1 and some clicked the button, he/she would get the warning (MsgBox), and after clicking 'OK' on the warning, the script would die.
Thanks in advance.
Bookmarks