Progress Bar while calling a macro

[Chandresh]

Hi All,

i have below recorded macro which is running fine and my data are accurate. i am calling all the macro in a below sequence.
just wanted to check if i can add any progress bar to check the progress of the macro.

Sub EveryThing()
    Call Macro3
    Call test
    Call Macro1
    Call Macro2
    Call CombineFiles
    Call Vlookupdta
    Call CombineData
    Call DeleteAllBut4
End Sub

Thanks
Chandresh

 

[RoryA]

There are thousands of progress bar examples on the internet - what have you tried so far?

 

[Chandresh]

i am checking if we can add progress bar while calling the macro

 

[RoryA]

I am aware of that - have you tried any of the many examples available from a Google search?

 

[Chandresh]

Yes i have created my own in userform with name P1Bar which has Textbox1 and Textbox2

 

[RoryA]

And where are you stuck specifically?

You might want to have a look at Andy's examples here: http://www.andypope.info/vba/pmeter.htm

 

[Chandresh]

Hi I am using below code and my display gets blank for first 30 to 40 seconds then after the form is visible.. don't know why its now visible for first few seconds

[Sub EveryThing()
Processing.Show vbModeless
Call Macro3
Call test
Call Macro1
Call Macro2
Call CombineFiles
Call Vlookupdta
Call CombineData
Call DeleteAllBut4
Processing.Hide
End Sub
[/CODE]

 

[Johnny C]

I presume you update the userform in the macros.
How do you update it,

    Processing.repaint

if so try

    DoEvents

as that reforces a repaint in some circumstances.