Hi guys,
I have a message box for a macro which says "Please pick a number".
Now, I have a list of pre-defined numbers which I wish the user to pick (which are in no sequential order, and there are about 3000 of them). I want the message box to say something like "please pick a valid number" and return to the "enter a number" message box if the user does not enter a number in my list. Help is greatly appreciated!
Thanks, Merry Xmas!
Frank
I have a message box for a macro which says "Please pick a number".
Now, I have a list of pre-defined numbers which I wish the user to pick (which are in no sequential order, and there are about 3000 of them). I want the message box to say something like "please pick a valid number" and return to the "enter a number" message box if the user does not enter a number in my list. Help is greatly appreciated!
Thanks, Merry Xmas!
Frank