Hello group
I am trying to figure out how to create a series of message boxes that if three conditions are met, it runs the macro.
1.) First a message box will ask for the user to input a value.
2.) It the user cancels or enters a blank it will exit the sub
3.) The value of the user input will be compared against a range say (A1 THRU A20).
1a.) if the value is not in the range a message box will alert that the value in not in the range and ask the user if they want to try again
1b.) if the user hits yes, it will loop to enter another value, if not it will exit the sub
1c.) if the value is in the range then the macro will run
Appreciate any responses
Kind Regards!
I am trying to figure out how to create a series of message boxes that if three conditions are met, it runs the macro.
1.) First a message box will ask for the user to input a value.
2.) It the user cancels or enters a blank it will exit the sub
3.) The value of the user input will be compared against a range say (A1 THRU A20).
1a.) if the value is not in the range a message box will alert that the value in not in the range and ask the user if they want to try again
1b.) if the user hits yes, it will loop to enter another value, if not it will exit the sub
1c.) if the value is in the range then the macro will run
Appreciate any responses
Kind Regards!