Adding a waiting 3D animated icon to code

[DThib]

Hello all,

My code is working as intended.
There is a long waiting period as a consequence of the code run that I would like to call a 3D animated model I have to just run onscreen while the code is running in the background.
I cannot figure out how to call it from VBA to appear as this happens.

Anyone have an idea?

DThib

 

[DThib]

Any ideas?

DThib

 

[Logit]

.
Maybe this will give you a start :

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

 

[DThib]

Thank you,

I have been trying that code. The animated icon I am using is from the Insert menu images.
I would like for it to run while the macro is executing code in the back. It takes a couple of minutes due to the content.

I am not sure if there is an easy way to just call the animated icon, but I am trying to not bog down the code anymore than I have to.

If it is not possible, that is OK.

DThib

 

[Logit]

.
Everything I've learned involves animated GIF and using the web browser control. Not exactly what you are seeking.

The thought behind the link provided is similar to creating a PROGRESS BAR in a userform. Instead of the bar the code would load the animated GIF.

Maybe between example code of a progress bar (tons of examples on the internet and forums) and loading the GIF you could create what you are seeking.