View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John[_22_] John[_22_] is offline
external usenet poster
 
Posts: 694
Default Prompting users with a message box on certain cells

Hi Tommy
Did you know you can get the same result with DataValidation
goto Input message and type your message. Also you got InsertComment.
Without a Macro
HTH
John

"tommy" .(donotspam) wrote in message
...
I am looking for a macro to do the following:

As soon as a User clicks on cells B18 or B24 or B37

a message box should pop up with my message (I already have the message
code)

I just need the code to tell it when a user selects one of the above
mentioned cells

--
thanx