Do While vs. Do until

I usually use Do Until.

Do Until Progressbar1.Value = 100
Progressbar1.Value = Progressbar1.Value + 1
DoEvents
Loop

You could also use the For..Next statement as well.

For i = 0 to 100
Progressbar1.Value = i
DoEvents
Next i