Msg "Waiting ..." when the macro runs.

[gio123bg]

Hi,
I have the necessity to run a macro with the message "Waiting ..." (using a message box).

If I use msgbox "Waiting ..." I need to press [OK] button but I wish to cancel the message box, automaticly, at the end of the macro.

Is it possible? Any idea?
Thanks in advance.

Giovanni

 

[SIXTH SENSE]

Hi!
You can use a user form for this.

 

[gio123bg]

Ok, thanks but I never used the user form. Is there an example?

Giovanni

 

[SIXTH SENSE]

Search for "Slash screen" or "Progress bar" in this board. there are a lot.
Im looking for my post for that

 

[SIXTH SENSE]

You got explaination here on how to.

http://j-walk.com/ss/excel/tips/tip34.htm