Status Bar as progress bar

**Rick_Stanich** · 04-29-2009, 02:36 PM

Im forgetting how to code something for this.

Please Login or Register  to view this content.

Im trying to show what row of the total rows are in process in the status bar.

Any help, tips, hints, etc is appreciated.

**royUK** · 04-29-2009, 03:27 PM

Is this what you mean?

Please Login or Register  to view this content.

**karan** · 04-29-2009, 03:32 PM

Try this:

Please Login or Register  to view this content.

--Karan--

**royUK** · 04-29-2009, 03:47 PM

Karan, I would not declare lRow as an Integer, the number of rows may be too high for an Integer.

**karan** · 04-29-2009, 03:53 PM

Yeah.. declaring it as long would be the right thing to do..

Cheers!!
Karan

**Rick_Stanich** · 04-29-2009, 03:54 PM

Originally Posted by royUK

Karan, I would not declare lRow as an Integer, the number of rows may be to high for an Integer.

I did not know this.

Is there a limit for an integer?

Roy, Karan, thank you.

**royUK** · 04-30-2009, 03:07 AM

The range of an integer is –32,768 to 32,767, for a list of variables see

http://www.excel-it.com/clear_code.htm

Did the code work OK?

**Rick_Stanich** · 04-30-2009, 11:50 AM

Yes, your code worked just fine.

re: Status Bar as progress bar