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
|