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