Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
automation difficulty
I have incorporated into a suite of macros a variation of the
"Displaying a Progress Indicator" developer tip that I found on j-walk's web site. I have adjusted for the following wrinkle: the process I wish to show progress for is not a repetitive action and is not in a loop, but rather is 12 sequential steps. I have gotten everything to work properly except for the automated aspect. My problem is that I must click on the close button on the upper right of the progress indicator dialog box for each successive step to be performed and the progress indicator to be advanced. This would be tolerable when processing single items at a time, but not when processing a lengthy list of 160 items at 12 steps each. What am I not doing correctly to allow this to be a single button push operation? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
automation difficulty
Assuming you are doing that to force an update of the progress bar:
after each update of the progress bar, add Userform1.Repaint DoEvents change useform1 to reflect the name of your userform. There should be no requirement to close and open it. -- Regards, Tom Ogilvy "DDMcH" wrote in message oups.com... I have incorporated into a suite of macros a variation of the "Displaying a Progress Indicator" developer tip that I found on j-walk's web site. I have adjusted for the following wrinkle: the process I wish to show progress for is not a repetitive action and is not in a loop, but rather is 12 sequential steps. I have gotten everything to work properly except for the automated aspect. My problem is that I must click on the close button on the upper right of the progress indicator dialog box for each successive step to be performed and the progress indicator to be advanced. This would be tolerable when processing single items at a time, but not when processing a lengthy list of 160 items at 12 steps each. What am I not doing correctly to allow this to be a single button push operation? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT Difficulty | Excel Worksheet Functions | |||
Difficulty in transposing | New Users to Excel | |||
VLOOKUP Difficulty | Excel Discussion (Misc queries) | |||
AutoFill difficulty | Excel Programming | |||
IF Statement difficulty | Excel Worksheet Functions |