Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
Progress Bar | Excel Programming | |||
Progress Bar | Excel Programming | |||
Calendar Control: Can't exit design mode because control can't be created | Excel Programming | |||
Progress Bar | Excel Programming |