Progress Bar Control

I am afraid at this point I cannot tell you as it depends. You need to
identify points in your code where you can insert the call to the PB. This
will have to be frequent, and meaningful to get the PB moving in a smooth
fashion.
--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"pianoman" <pianoman.2913dn_1149677702.7883@excelforum-nospam.com> wrote in
message news:pianoman.2913dn_1149677702.7883@excelforum-nospam.com...
>
> Ok, so Code wise, I need to call the PB at the start of my code using
>
> call Show()
>
> then insert
>
> call updatestatus()
>
> at regular points in my code...?
>
> Something like that?
>
> I don't understand how to adapt the demo on the site to fit my own
> codes... maybe I lef tmy brain at home this morning, but this isn't
> clicking at all today!
>
> Thanks,
>
>
> --
> pianoman
> ------------------------------------------------------------------------
> pianoman's Profile:
http://www.excelforum.com/member.php...o&userid=33712
> View this thread: http://www.excelforum.com/showthread...hreadid=549368
>

Hi Bob,
Thanks for sticking with me!

I must not have been clear in my last post... I understand I will have to insert 'interupts' in my code... that's fine, but how do i 'Call' the relevant subs from my code. When I try to call subs in the Progress module, it won't find them 'cause they're all private subs.

How do I call the bits I need to Call, and then what is it I need to insert to add the interupts?

Thanks,

OK, I see now.

You don 't call the subs, it is a class module, so you would invoke the
methods via the object, but Robin actually does it via a property. You set
the property with a value that will translate to the width. For example,
looking at the demo

Set PB = New clsProgBar

This initiates the PB class.

With PB

This sets a link to your PB object

.Title = "Enhanced Datasystems Progress Bar"
.Caption2 = "This is caption 2"
.Caption3 = "This is caption 3"
.Show

This initialises the PB and displays it, and then the next bit is your main
loop where you will repeatedly call the PB



For nCounter = 0 To 100

.Progress = nCounter
.Caption1 = "Progress message " & CStr(nCounter)

This is the meat, where you pass it your current progress index which the PB
class uses to update the PB meter.

Is that clear?



--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"pianoman" <pianoman.2917rz_1149683402.5809@excelforum-nospam.com> wrote in
message news:pianoman.2917rz_1149683402.5809@excelforum-nospam.com...
>
> Hi Bob,
> Thanks for sticking with me!
>
> I must not have been clear in my last post... I understand I will
> have to insert 'interupts' in my code... that's fine, but how do i
> 'Call' the relevant subs from my code. When I try to call subs in the
> Progress module, it won't find them 'cause they're all private subs.
>
> How do I call the bits I need to Call, and then what is it I need to
> insert to add the interupts?
>
> Thanks,
>
>
> --
> pianoman
> ------------------------------------------------------------------------
> pianoman's Profile:
http://www.excelforum.com/member.php...o&userid=33712
> View this thread: http://www.excelforum.com/showthread...hreadid=549368
>