Progress Bar while calling a macro

Chandresh

Board Regular
Joined
Jul 21, 2009
Messages
146
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.

Code:
Sub EveryThing()
    Call Macro3
    Call test
    Call Macro1
    Call Macro2
    Call CombineFiles
    Call Vlookupdta
    Call CombineData
    Call DeleteAllBut4
End Sub
Thanks
Chandresh
 
Last edited by a moderator:

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
There are thousands of progress bar examples on the internet - what have you tried so far?
 
Upvote 0
I am aware of that - have you tried any of the many examples available from a Google search?
 
Upvote 0
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]
 
Upvote 0
I presume you update the userform in the macros.
How do you update it,
Code:
    Processing.repaint
if so try
Code:
    DoEvents
as that reforces a repaint in some circumstances.
 
Upvote 0

Forum statistics

Threads
1,213,565
Messages
6,114,338
Members
448,569
Latest member
Honeymonster123

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top