Popping up "Please wait" msg

[cogar]

Hello all,

say I have a VBA routine that will run for quite some time, how can I have a pop-up msg to tell the user to wait and to automatically disappear upon comletion whenever the routine is called?

Thank you so much.

[stoney1977]

Hello all,

say I have a VBA routine that will run for quite some time, how can I have a pop-up msg to tell the user to wait and to automatically disappear upon comletion whenever the routine is called?

Thank you so much.

You could use a userform and just make it show at the start of the code and unload at the end.

Or

Use the application status bar.

[royUK]

I would first of all check whether the code could run more efficiently. If it still takes a long time then have a warning message on a hidden sheet which is unhidden at the start of the code & re-hidden at the end

[davesexcel]

Hello all,

say I have a VBA routine that will run for quite some time, how can I have a pop-up msg to tell the user to wait and to automatically disappear upon comletion whenever the routine is called?

Thank you so much.

Hi cogar,
Let's see the code....