Progress bar in excel, then call another macro

[abadilala]

<tbody>
[TD="class: votecell"]0down vote favorite
[/TD]
[TD="class: postcell"]I have 2 macro. One for progress bar, and the other one is the main process. The main process consist of 4 sub process inside.
What I want to do is the progress bar increase 25% for each process.
I have created the progress bar macro as below:

<code>Sub code() ' ' Macro1 Macro ' ' Keyboard Shortcut: Ctrl+p 'Sub code()

UserForm1.Show

End Sub

Sub progress(pctCompl As Single)

UserForm1.Text.Caption = pctCompl * 25 & "% Completed"

UserForm1.Bar.Width = pctCompl * 50
DoEvents

End Sub

Sub code_real()

Dim i As Integer, j As Integer, pctCompl As Single

Sheet1.Cells.Clear

For i = 1 To 4

For j = 1 To 10000

Cells(i, 1).Value = j

Next j

pctCompl = i

progress pctCompl

Next i

End Sub

</code> My question is, how can I call main process macro while the macro for progress bar is running? I heard only 1 macro can be run at a time.

[/TD]

</tbody>

 

[igold]

Cross-Post:

https://stackoverflow.com/questions/46725914/progress-bar-in-excel-call-another-macro