I have created a progress bar with four labels in an userform, changing the color in run time with the help of timer. Is that possible to add a progress bar while running a macro? And not with pictures.
If I am not wrong, there is a progress bar active x control. You can use that to show progress. And in your main macro you can update it as the progress happens. You can even do the updates asynchronously using timer etc.
I would like to show an animated picture in the user form (instead of progress bar). But unable to get the animation while the user form is running. It doesn't work after installing ‘AniGIF.ocx’(A control for adding Animated images).
Please guide me how to get the animation while user form is running?