Thread: Status Message
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Status Message

Ray,

In Excel 2000 and later, you can use a userform to display the
message and keep code running while the form is displayed. For
example,

UserForm1.Show vbModelsss


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Ray Batig" wrote in message
link.net...
Is there a simple way to pop up a message type box with a

variable message
that would stay around for two seconds and then disappear? I

would like to
not stop the main macro from running during the time the box is

in view. I
have some very long procedures that I would like to show some

simple
indication of progress.

Merry Christmas. Thanks in advance for your help!

Ray