[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?
Re: [EXCEL] Creating A Progress Bar
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
Code:
test.Show vbModeless