Hi!
I was wondering if there were any way to stop a script in the middle of the process, display a text box on why the script has stopped and then exit the procedure (without finishing the procedure).
I understand that I of course have to write the text in the box myself.
An example could be:
If you have an operation that transfer a value that the user is supposed to write to another sheet, which then delivers several other values based on the first value you wrote to another sheet that is supposed to perform a calculation. If that value is not written you will get an error message "Run time error 1004", which pass you back to the code.
I want to stop the script before that to tell the user to input numbers on the right places.
Preferably the message should be something like " Input values in either Cell D4 or the cell range: G4,H4,I4".
Then exit the script.
Bookmarks