Warning Message Box

[Jimmy110]

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

 

[Michael M]

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

Post the macro you are currently using and we can modify it to suit

 

[Peter_SSs]

Put this right near the start of your macro

If Range("E2").Value = "!!!SELECT LINE & REASON!!!" Then
  MsgBox "Whatever you want the warning to say"
  Exit Sub
End If

 

[Jimmy110]

That's worked perfectly....thank you

 

[Peter_SSs]

You're welcome. Thanks for the confirmation.