Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
progress bar issues
Hi EVeryone,
I have seen many posts within this group in regards to progress bars and how to make them, but the issue I am having right now is that as soon as the userform appears to tell me waht stage it's at in the macro.... the macro stops until i close the userform. my code has many for loops one after another and opens many other workbooks for interaction... i'd like the users to get a note stating what progress is done or where the are right now. Any help on this is apprecieated |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
progress bar issues
Maybe you forgot 'DoEvents'.
Here's a sample: Private Sub Button_GoProgressGo_Click() Dim i As Integer ProgressBar1.Min = 0 ProgressBar1.Max = 10000 For i = 0 To 10000 DoEvents ProgressBar1.Value = i Next i End Sub "Phil" schreef in bericht ups.com... Hi EVeryone, I have seen many posts within this group in regards to progress bars and how to make them, but the issue I am having right now is that as soon as the userform appears to tell me waht stage it's at in the macro.... the macro stops until i close the userform. my code has many for loops one after another and opens many other workbooks for interaction... i'd like the users to get a note stating what progress is done or where the are right now. Any help on this is apprecieated |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
progress bar issues
Show the form and call your code from the form activate event...
Private Sub UserForm_Activate Call RunMyLoops Call OpenOtherWorkbooks Me.Hide End Sub The called subs will have to have code in them to update the form; and yes use DoEvents. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Phil" wrote in message Hi EVeryone, I have seen many posts within this group in regards to progress bars and how to make them, but the issue I am having right now is that as soon as the userform appears to tell me what stage it's at in the macro.... the macro stops until i close the userform. my code has many for loops one after another and opens many other workbooks for interaction... i'd like the users to get a note stating what progress is done or where the are right now. Any help on this is appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Progress Bar | Excel Discussion (Misc queries) | |||
Progress bar | Excel Discussion (Misc queries) | |||
NEED Help - How to capture the Event's progress in Progress Bar | Excel Programming | |||
using of progress bar | Excel Programming | |||
Progress Bar | Excel Programming |