"Alok" schrieb

Hi Alok,

Hi Peter

Place the ProgressBar and CommandButton on a form and then add this code.

Private Sub CommandButton1_Click()
Dim i%
For i = 1 To 100
ProgressBar1.Value = i
Next i
End Sub

Seems to work for me but I am using Excel 2003. The progressbar does not
have a design time property of value but it does have a run-time value
property as you see above.


Great! It was working right away. Thanks a lot.
Now I have good hope to be able to get it integrated
it into my application. ;-)

Greetings from Germany
Peter Ostermann