Using "For" for multiple macros, How to do it?

[radian89]

Hi all,

I have 3 macros called :
RegGenerate
AreaGenerate
ZoneGenerate

then i want to make 1 module to run all this 3 macros, using "For", you might ask why? this is because i want to use progress bar to inform user, what macros that currently going

my current on going code is like this, i have to re-write all this code for each macros, that's so dumb & inefficient. so i want to use "for" to create this progress bar. is there any way to do this?

frmProgressBar.Show    counter = 0
    JmlOnGoing = 3
    
    '--------------------------------------------------
    'update progress bar
    
    counter = counter + 1
    JmlDone = counter
            
    With frmProgressBar
        .Label1.Caption = "Zone creation in Progress"
        .Bar.Width = JmlDone * (.Frame1.Width / JmlOnGoing)
    End With
            
    DoEvents
    
    Call ZoneGenerate

thanks for the help
warm regards

Adrian