Excel Macro

A

AQ Mahomed

Hi

Is is possible within Excel to create som type of status box
while running a macro.

This status box will give a bar that will indicate how far the macro is.

Many Thanks
AQ


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
 
P

Pete McCosh

AQ,

there are a couple of options. You can put comments on
Excel's status bar to advise on the progress of your code:

Application.StatusBar="Doing some stuff"
....
Application.StatusBar="Nearly Finished..."
....
Application.StatusBar=False

The last line clears resets the status bar. If you don't
do this, you'll be left with the last message you sent for
the rest of the day.

If that's not visual enough, Chip Pearson has an add-in
you could try:

http://www.cpearson.com/excel/Progress.htm

Cheers, Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top