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?