How can I add a progress bar to a loop?

JumboCactuar

Well-known Member
Joined
Nov 16, 2016
Messages
609
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
 

Forum statistics

Threads
1,078,337
Messages
5,339,632
Members
399,316
Latest member
LeroyWork

Some videos you may like

This Week's Hot Topics

Top