Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Progress Bar Control


Hi All,
I've had a look through previous posts, and discovered the Microsoft
ProgressBar Control, which looks fine for what I need, but I can't find
any useful support on it from anywhere! How do I link it to my sub?

Thanks,


--
pianoman
------------------------------------------------------------------------
pianoman's Profile: http://www.excelforum.com/member.php...o&userid=33712
View this thread: http://www.excelforum.com/showthread...hreadid=549368

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,058
Default Progress Bar Control

See:


http://groups.google.com/group/micro...4ae4a6a8c4d49a
--
Gary''s Student


"pianoman" wrote:


Hi All,
I've had a look through previous posts, and discovered the Microsoft
ProgressBar Control, which looks fine for what I need, but I can't find
any useful support on it from anywhere! How do I link it to my sub?

Thanks,


--
pianoman
------------------------------------------------------------------------
pianoman's Profile: http://www.excelforum.com/member.php...o&userid=33712
View this thread: http://www.excelforum.com/showthread...hreadid=549368


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Progress Bar Control


Thanks Gary's Student, but this isn't quite what I need... Th
ProgressBar Cntrol is a seperate entity that you can paste onto you
sheet, add text, whatever... the search you made will only allow me t
access the green status LED's in the bottom window, unless I hav
misread of course...

Thanks,

Garet

--
pianoma
-----------------------------------------------------------------------
pianoman's Profile: http://www.excelforum.com/member.php...fo&userid=3371
View this thread: http://www.excelforum.com/showthread.php?threadid=54936

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,593
Default Progress Bar Control

I would use this PB
http://www.enhanceddatasystems.com/E...rogressBar.htm

--
HTH

Bob Phillips

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

"pianoman" wrote in
message ...

Hi All,
I've had a look through previous posts, and discovered the Microsoft
ProgressBar Control, which looks fine for what I need, but I can't find
any useful support on it from anywhere! How do I link it to my sub?

Thanks,


--
pianoman
------------------------------------------------------------------------
pianoman's Profile:

http://www.excelforum.com/member.php...o&userid=33712
View this thread: http://www.excelforum.com/showthread...hreadid=549368



  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Progress Bar Control


Thanks for that Bob,
I did see your suggestion in a previous post, but I couldn't see ho
to use it... Where to I post my code? Presumably I have to sandwic
the longest part of the sub in there somewhere...?

I've copied the two modules into my project, as instructed on the we
site... now what?!

Thank you,
Garet

--
pianoma
-----------------------------------------------------------------------
pianoman's Profile: http://www.excelforum.com/member.php...fo&userid=3371
View this thread: http://www.excelforum.com/showthread.php?threadid=54936



  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,593
Default Progress Bar Control

You have to call the PB at various points within your processes. That is
true with any PB, You will need to look at your code and see where to
install the PB interrupts.

Robin provides a demo, which you can look at to see how to use it.

--
HTH

Bob Phillips

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

"pianoman" wrote in
message ...

Thanks for that Bob,
I did see your suggestion in a previous post, but I couldn't see how
to use it... Where to I post my code? Presumably I have to sandwich
the longest part of the sub in there somewhere...?

I've copied the two modules into my project, as instructed on the web
site... now what?!

Thank you,
Gareth


--
pianoman
------------------------------------------------------------------------
pianoman's Profile:

http://www.excelforum.com/member.php...o&userid=33712
View this thread: http://www.excelforum.com/showthread...hreadid=549368



  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Progress Bar Control


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 ow
codes... maybe I lef tmy brain at home this morning, but this isn'
clicking at all today!

Thanks

--
pianoma
-----------------------------------------------------------------------
pianoman's Profile: http://www.excelforum.com/member.php...fo&userid=3371
View this thread: http://www.excelforum.com/showthread.php?threadid=54936

  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,593
Default 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" wrote in
message ...

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



  #9   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default Progress Bar Control

this approach documented at John Walkenbach's site is extremely easy and
should help you understand the concepts.

http://www.j-walk.com/ss/excel/tips/tip34.htm

I haven't used Rob's code, but I wouldn't doubt it is based on the same
principle, but encased in a class module.

The important point is that the progress bar has no built in intelligence
(or timers) - you have to tell it (in your code) to update and to update to
what value at the appropriate points.

One caution on limitations: Many people would like to show a progress bar
when saving a file that takes a long time to save (as an example). since
this is a single command, there is no way the code can update a progress bar
during the save.

--
Regards,
Tom Ogilvy


"pianoman" wrote:


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


  #10   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Progress Bar Control


Thanks Tom,
Ok, I'm starting to grasp bits of this function now! I'm a littl
confused about how I adapt the code below (part of the JWalk example
which wraps a couple of lines which repeat several thousand time in th
progress code, to fit my coding, which has a couple of looping section
but mainly works through in a linear fashion, without a single sectio
that I can integrate into an incrementing 'loop'.

I have 25 pages of code so can't really post it, but I'd be happy t
send it to someone if that would make it any clearer...


Counter = 1
RowMax = 100
ColMax = 25
For r = 1 To RowMax
For c = 1 To ColMax
Cells(r, c) = Int(Rnd * 1000)
Counter = Counter + 1
Next c
PctDone = Counter / (RowMax * ColMax)
With UserForm1
.FrameProgress.Caption = Format(PctDone, "0%")
.LabelProgress.Width = PctDone * (.FrameProgress.Width
10)
End With
' The DoEvents statement is responsible for the form updating
DoEvents
Next r


Thank you,
Garet

--
pianoma
-----------------------------------------------------------------------
pianoman's Profile: http://www.excelforum.com/member.php...fo&userid=3371
View this thread: http://www.excelforum.com/showthread.php?threadid=54936



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2007 Form Control/ActiveX Control font difference Nikko963 Excel Discussion (Misc queries) 0 April 15th 09 04:21 PM
Progress Bar John Excel Programming 21 July 8th 05 05:45 PM
Progress Bar Karen[_12_] Excel Programming 0 June 14th 04 06:42 PM
Calendar Control: Can't exit design mode because control can't be created Rone Excel Programming 0 May 24th 04 04:01 PM
Progress Bar Syed Zeeshan Haider[_7_] Excel Programming 2 May 21st 04 01:33 PM


All times are GMT +1. The time now is 12:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"