How can I add a progress bar to a loop?

JumboCactuar

Well-known Member
Joined
Nov 16, 2016
Messages
681
Hi,
I've never done anything before with progress bars.

I have a macro which loops through a worksheet to last row and the data is used to update an external program.

The problem is if there are a lot of rows (1000+)
Then excel freezes up until finished.

Is it possible to add a progress bar? I could add a counter to the loop and this could be used for it.

Thanks
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Watch MrExcel Video

Forum statistics

Threads
1,099,254
Messages
5,467,565
Members
406,543
Latest member
semoredhawk

This Week's Hot Topics

Top