progress bar issues

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

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
 
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
 
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" <[email protected]>
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
 
Back
Top