processing message

[hans]

I have a macro that takes quite a long to run and I would
like to show some kind of message during processing,
like "Please wait - data being processed". What is the
best way to do this?

Hans

 

[Don Guillett]

try

application.statusbar="your message here"
code
appliation.statusbar=""

 

[Bob Phillips]

Create a form with that message on and launch your macro from the form code.

If you want to show a progress bar, here are a few examples of good 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

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Guest]

If you used MsgBox to show your message, the macro will halt and wait for user interaction. You can show a form with a progres bar-- overkill, I think

I would show the message on the application.status bar (help file) and turn the mouse pointer to an hourglass.

 

[Hans]

thanks

-----Original Message-----
try

application.statusbar="your message here"
code
appliation.statusbar=""

--
Don Guillett
SalesAid Software
(e-mail address removed)



.

 

[Don Guillett]

This was a simple approach but what you asked for.