Hi All,
Looking for some help to create a warning message box. Basically, I have a macro on a shape that when clicked transfers some data to another sheet. What I would like to do is have it flag up a warning box if the value of cell E2 is equal to !!!SELECT LINE & REASON!!! (To prompt the user from running the macro and copying the data if they haven't already picked something other than !!!SELECT LINE & REASON!!! from the drop down list.
Any help appreciated...and please treat me as an absolute beginner....because I am LOL
Thank you
James
Looking for some help to create a warning message box. Basically, I have a macro on a shape that when clicked transfers some data to another sheet. What I would like to do is have it flag up a warning box if the value of cell E2 is equal to !!!SELECT LINE & REASON!!! (To prompt the user from running the macro and copying the data if they haven't already picked something other than !!!SELECT LINE & REASON!!! from the drop down list.
Any help appreciated...and please treat me as an absolute beginner....because I am LOL
Thank you
James