Message Box in VBA to say Please Wait

jts2004

Board Regular
Joined
Apr 21, 2004
Messages
156
I have a macro that takes about 30 sec. I would like a message to pop up saying "please wait" the disappear after the macro ends. Will this slow up my macro even more?
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
Good afternoon jts2004

You will need to design a userform (go to Insert > Userform from the VBE) which is simplicity itself and use this call to show it (assuming you name it UserForm1):

Userform1.Show

and to dismiss it:

Unload UserForm1

A MsgBox wouldn't be suitable in this instance as it needs user intervention to be closed.

HTH

DominicB
 

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
Hi jts2004

And try this trick to speed up your macro. Make the first line after the Sub() statement:

Application.ScreenUpdating=False

and this directly before the End() statement:

Application.ScreenUpdating=True
HTH

DominicB
 

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,014
DominicB said:
...Userform1.Show...
Needs small edit...
Code:
    UserForm1.Show vbModeless
otherwise code will still hang, awaiting user input.
 

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569

ADVERTISEMENT

Whoops!!!!!

Thanks for that Greg!

DominicB
 

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,014
NP. Now, let's see if jts understood your first post and was able to implement it. :wink:
 

Watch MrExcel Video

Forum statistics

Threads
1,118,812
Messages
5,574,456
Members
412,595
Latest member
slim313
Top