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

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

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,123,425
Messages
5,601,580
Members
414,460
Latest member
uctc

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top