View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tommy tommy is offline
external usenet poster
 
Posts: 8
Default Prompting users with a message box on certain cells

Sorry,
but I dont want to use Insert Comment or Data Validation

I want the message box to pop up since it forces the user to read and click OK
--
thanx


"John" wrote:

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