Displaying a Status Bar... 1

[dc20]

Hi,
I have a vba program that can run from 1/4 minute to 2 minutes depending on the size of the spreadsheet it's working on. I could come up with a factoring method or use Timer or something to feed a status bar to show progress, but I'm not sure how to go about getting the visual of a status bar. Create it in a form ? or is there something available in windows to grab ? If created from scratch, any ideas ? - blacking out a bunch of little label boxes doesn't look that great. LOL. I have ScreenUpdating false to reduce time, so it would be easy for a novice user to think it might be hung-up, although in the program info, I do communicate the range timeframe.

thanks in advance,
Dave.

 

[SBendBuckeye]

Hello,

Hopefully this will be enough to get you started.

1. Turn the status bar on/off
Application.DisplayStatusBar = True/False

2. Get current state
? Application.DisplayStatusBar

3. Set it to some text
Application.StatusBar = "Your message goes here"

4. Set it back to Ready when done
Application.StatusBar = False

Good Luck!

Have a great day!

j2consulting@yahoo.com

 

[dc20]

That works just great and so easy to use. I could have used that while I was developing the program !

thanks !