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

try

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

--
Don Guillett
SalesAid Software

"hans" wrote in message
...
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

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/E...rogressBar.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)

"hans" wrote in message
...
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

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.

thanks


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

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

--
Don Guillett
SalesAid Software

"hans" wrote in
message
...
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




.

This was a simple approach but what you asked for.

--
Don Guillett
SalesAid Software

"Hans" wrote in message
...

thanks


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

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

--
Don Guillett
SalesAid Software

"hans" wrote in
message
...
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




.