Kill the Script

I have a button activated macro, which does a bit of Goal Seeking.

Please Login or Register  to view this content.

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.

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.

You can't use "target" in a regular manually activated macro, at least it's not standard to try. You need to name your objects directly.

Please Login or Register  to view this content.

Hello BazzaBoy,

Unless you have declared the variable Target as Public at the top of your module, this code won't work. I am assuming this cell $EY$3 is on the ActiveSheet. If so change your code to this...

Please Login or Register  to view this content.