Aborting code after a MsgBox has been clicked

Hi

I am using an If function to test for incorrect input (for instance, when the input is too high). A MsgBox then appears saying "The value is too high". When the user clicks "OK", I want my code to stop. How do I do this?

Thanks
Luke

Hi Luke
Something like this will do it. Enter a number in A1, the message box appears & quits the routine after OK is pressed

Please Login or Register  to view this content.

Thank you! Precisely what I was looking for!

That's good