View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default If A0, I need a message pop-up box to show text in B1

You didn't bother to answer the question on how A1 would change. But it
sounds like it might be changed by a macro. If so, use the same macro to
pop up the message box, i.e change the value of a1 and show the message box
in the same procedure. .

--
Regards,
Tom Ogilvy

wrote in message
ups.com...

Tom,

There is perhaps a better way to approach my problem. A one time
pop-up would be great, and without an OK button if I could make it
remain for approximately 10 seconds. It would not need to repeat
itself. The next message would pop-up only if there were to be a
change in the A1 value.

Also, assuming there would be an A1 type of construct in multiple
worksheets, would there need to be more than a single UserForm?

Thanks,

Michael