Info message while macro runs

[LB79]

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 click about th
screen thinking it has hung. Is there a way i can have a message bo
that has no button (OK/YES) that shows only while the macro is runnin
to tell the user what the workbook is doing.
Thank

 

[icestationzbra]

i could suggest a way. i have tried it, but a while ago. so i do no
remember, how i went about doing it.

create a userform with the message that you want to show. you ca
design it to not have any sort of buttons. you can also disable the
mark. make the userform modal in nature, so that during the executio
of macro, the excel sheet cannot be clicked on. then, at the completio
of the execution, unload the userform

 

[Frank Kabel]

Hi
you may have a look at the
following sites for some intetresting progress bars:
http://www.enhanceddatasystems.com/ED/Pages/ExcelProgressBar.htm
http://www.cpearson.com/excel/Progress.htm
http://j-walk.com/ss/excel/files/developer.htm

 

[Dave Peterson]

I'd use the application.statusbar and teach your users how to notice/read that
statusbar.

application.statusbar = "please wait a while...."
'your code
application.statusbar = false 'to give it back to excel