[RESOLVED] [EXCEL] Creating A Progress Bar

[agmorgan]

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

    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?

[agmorgan]

Amazing what a different perspective on things comes up with!
Searched for vba userform continue background excel and and came up with this
http://www.ozgrid.com/forum/showthread.php?t=28949

Just need to start it with

test.Show vbModeless