PDA

View Full Version : Adding progress bar to existing code



fadib
09-16-2012, 04:04 PM
Hey Guys,
I want to add a progress bar at certain location in a code ( I will pick the lcation by inserting ProgressBar 0.2 for example).

I know how to create the frmprogressBar form.

What I don't know, is to how to embeded if my code is in a sheet.

Can someone explain to me the architecture of the setup. Should it be all in modules, how can I call out, and how does the useform stays on.

I have added my practice Book1.xls with an error a bit confused :confused: . Actually Lost...

Need a hand please...

snb
09-17-2012, 12:56 AM
If you improve your coding you probably won't need any progressbar.
If your code is fast the progressbar won't even be visible.

mancubus
09-17-2012, 12:59 AM
hi,

http://www.andypope.info/vba/pmeter.htm

fadib
09-17-2012, 05:31 AM
If you improve your coding you probably won't need any progressbar.
If your code is fast the progressbar won't even be visible.

you are right, the reason behind this is the practice. I will use Sleep command to slow it down. I just want to know what to put as a module and how to position the code and reference it.

fadib
09-17-2012, 05:34 AM
hi,

http://www.andypope.info/vba/pmeter.htm

Actually Mancubus, this is what I have found online and drove me nuts.
Cause it is in userform with a button to show 60%.... I want to do the same but call out the progressbar when I want, and I need to use a module for that.
But couldn't figure it out.