progressbar for dummies

[kendel]

Hello,
There's so much information regarding this, and all I've found requires more knowledge than I have.
Please walk me thru it:
1. create the progressbar. Look like a file saving. simple, no text, no bells no whistles. Totally clueless here! VB editor? Worksheet code? Where to begin?
2. embed it into my macros, so it's only visible when I run the macros using a keyboard shortcut.

I thought it'd be simple but the more I researched it the more confused I am. Hehe, if you've run across me before you'll see that that is a common thread in all my inquiries.
The more I learn the more I find that I want to learn.

How about a MrExcel Vs Excel is Fun YouTube dueling podcast?!! Then there will forever be the definitive answer to the Progressbar question!!!


Thanks for any help,
Kendel (WinXP,Excel 2007 at work; Win7, Excel 2010 at home)

 

[kendel]

Thanks for the help guys, Have a great weekend!
Kendel

 

[bensonsearch]

Hey Benson,
When I put the code into the macro, no progressbar.
Did we miss step 1? or is the progressbar self creating and I put it in the wrong place? I guessed just before 'next i'. I guess my options here are: before 'next i'
before 'if'
or after 'For i'.
Thanks again!
I am so dreaming that this will be as painless as it seems.
Kendel

Hi,
You will need to add the progress bar control. with the loop be something like

On Local Error Resume Next
    ProgressBar1.Min = 0
    ProgressBar1.max = ProgressMax + 1
 
For i something something

    ProgressBar1.Value = ProgressBar1.Value + 1
'rest of your code in loop
 
next i