Progress bar VBA based on time not steps

armchairandy

Board Regular
Joined
Mar 27, 2012
Messages
51
I have a progress bar which is based on a loop code.

what I need is some code that will run the progress bar based on a time value located in a cell. The macro I am running is a mixture of copying & pasting from one sheet to another, running filters, deleting data and re-sorting. I have no idea how I could get the loop code to work with this. I have worked out how long it should take based on how may lines there are (variable each time), and I have this as an estimated time in a cell. Is there a way I can run the progress bar from 0% to 100% to coincide with the time I have estimated.

Andrew
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Watch MrExcel Video

Forum statistics

Threads
1,098,855
Messages
5,465,095
Members
406,412
Latest member
superjoejoe

This Week's Hot Topics

Top