Display Message While Running Macro

[Db1712]

I have a macro that does quote a few things and takes for 5 to 1
seconds to run. Ive noticed that users of my sheet somewhat freak ou
because the macro runs thru several pages and the users think that th
computer has a problem. Is there a way i can have a message box o
blank page with a message displayed that has no buttons (OK/YES) tha
shows only while the macro is running to tell the user what th
workbook is doing. Something simple not very good with VB
Thank

 

[L. Howard Kittle]

Hi Db....

If I understand correctly this may solve your problem. At the beginning of
your code enter:

Application.ScreenUpdating = False

At the end of your code enter:

Application.ScreenUpdating = True

That will stop the sheets jumping about.

HTH
Regards,
Howard

 

[Dave Peterson]

After you've hidden the screen jumping around with Howard's suggestion, you can
put a message on the statusbar. It's right below the VCR like controls that
control the worksheets (bottom left corner).

application.statusbar = "Hey, just settle down. It'll take 3 seconds!"

'your code

application.statusbar = false 'return control to Excel.

And you can change this statusbar as many times as you want to indicate what
your code is doing. Just end with the "=false" version.