• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macro - Progress bar control

Dhamo

New Member
Hi,


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.
 
Thanks much Chandoo.!


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?
 
Good day Dhamo


This link may be of help.


http://www.vbaexpress.com/kb/getarticle.php?kb_id=19
 
Thanks Bobhc.


I tried this, but the link is showing 8-9 pictures with timer control and all're jpeg, not gif (animated pictures).
 
Back
Top