[RESOLVED] [EXCEL] Creating A Progress Bar

I'm using the example from here to create a progress bar in my VBA
http://spreadsheetpage.com/index.php...ess_indicator/

I took all the code out from inside the userform and I am now trying to use it in the following way

Code:

Dim test As UserForm1 Set test = New UserForm1 test.LabelProgress.Width = 0 test.Label1= "Pre-Processing" test.Show For i = 1 to 10 test.Label1= "Pre-Processing " & i '... '... '...

However, once the form is showing, the code doesn't step into the loop.

The example on the website is loading the form then calling the processing.
I'm not really in a position to do that, which is why I am trying it this way.

What have I missed?