Link to home
Create AccountLog in
Avatar of hindersaliva
hindersalivaFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Excel 2013 - progress bar

To give a visual indication of progress in a loop I've been using something like this on each time round the loop.

    Sheet2.Shapes("Rectangle 9").Width = intWidth

To make it work I generally need a
Application.ScreenUpdating = True (though I'm not sure why, since I have not turned it off)

Anyway, I was wondering if anyone knows of a slicker way of doing this?
Maybe something that uses the Windows API?
Thanks
Avatar of hindersaliva
hindersaliva
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

Found a way with Conditional Formatting. It works
http://www.howtogeek.com/howto/45677/how-to-create-progress-bars-in-excel-with-conditional-formatting/

Any other methods?
Avatar of Steve Knight
Listening here for other interesting ways.... have used similar to above, or updated a counter cell, also updated the status bar with info or string of | characters etc - that works then with screenupdating false too.  

on phone at mo. but will have a look at your other link on pc later.

steve
ASKER CERTIFIED SOLUTION
Avatar of [ fanpages ]
[ fanpages ]

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Thanks fanpages!

Doh! I should have searched EE first. That's all the stuff I need.
Thanks.
Avatar of [ fanpages ]
[ fanpages ]

:)

You're welcome!