VBA code to update popup progress bar

[Dan Ahmadi]

Hello Everyone,

I have a particularly lengthy macro I am running in VBA. I would like a popup window that displays the current progress. What I have so far is the window popping up and when I am in break mode I can see that the values it is supposed to use to update its completion ratio are in fact updating. Unfortunately, however, the meter stays at zero the whole time. Is there some script I can add to periodically update this meter?


I should add also, that I have a form set up called UserForm1 in which the following code refers to. I'm new to coding so please excuse me if I am using the wrong terminology.

Thanks,


Here is the code I am using (truncated except all the relevant parts).:

Please Login or Register  to view this content.

[johncassell]

Hi, I couldn't quite figure out what your code was trying to do but hopefully this simple code will help you towards your goal..

Please Login or Register  to view this content.

Let me know how you get on.

John

[Dan Ahmadi]

Thanks John,

I think I found my mistake.