Macro Status 1

[bdmangum]

Through the use of Excel forms, I have created a database. This database will become a large file (thousands of rows), thus one macro which requires a look at all of the rows for comparision reasons will take a long time to run.

I'm attempting to create a loading/status message window which shows the user a macro is running. If possible I would like to add a progress bar to the message window which shows how far along the macro is currently. Basically something similar to the progress bar when installing a new program.

Does anybody know how to do this in Excel VBA?

 

[SkipVought]

Hi,

I put messages in the statusbar.

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}

 

[rmikesmith]

If you want it in a Userform (along with a displayed message), there are a number of implementations available. Here are links to two of them:

From John Walkenbach's 'The Spreadsheet Page'

http://www.j-walk.com/ss/excel/tips/tip34.htm

From Chip Pearson's site

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

Regards,
Mike