Excel %Progress Countdown/Barchart

Hi Heidi

Thanks for getting in touch. There's a whole range of ways you can accomplish this depending on how much you want to prevent the user working whilst the progress continues, and what you want it to look like.

There are many resources online to help with this. Here are a couple I tried out in researching your answer:

http://www.tushar-mehta.com/excel/tips/progress_bar.html

http://www.andypope.info/vba/pmeter.htm

Have a look at those and see if they meet your requirements.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector