frmProgressIndicator.Show
Call macro1
frmProgressIndicator.updateProgress (10)
Call macro2
frmProgressIndicator.updateProgress (20)
'Etc etc
frmProgressIndicator.updateProgress (100)
'maybe pause for a second then
frmprogressindicator.Hide
Apologies change the form Property ShowModal to False, or just download the updated file, and it will work just fine as it does with this code, as I forgot that option initially:This is good. The issue is that when the first box comes, you have to close it for the rest to continue, and the the other boxes dont come up
Private Sub MacroTest()
frmProgressIndicator.Show
Application.Wait (Now + TimeValue("00:00:01"))
For i = 1 To 10
frmProgressIndicator.updateProgress (i * 10)
DoEvents
Application.Wait (Now + TimeValue("00:00:01")) ' Simulate Macro execution
Next i
Application.Wait (Now + TimeValue("00:00:01"))
frmProgressIndicator.Hide
End Sub
Works amazing! Last question, how could I make it appear in the center of the workbook?