Animated gif on UserForm during running macro

[Equilibrium31]

Hello,

I have a macro that I run on a daily report which performs several steps including importing data from other spreadsheets and formatting data, creating pivot tables, etc. However, I am hoping that there is a way to create a UserForm with an animated gif that can be displayed while the macro runs to let the user know that the macro is running.

I have been able to create a UserForm for this with an animated gif by using the Web Browser function and have chosen a gif with a relatively small file size. However, when I run this UserForm in conjunction with the macro, the Web Browser is slow to load and either does not load until the macro is almost finished running or doesn't display at all.

I have tried turning off screen updating, but this just causes the gif to only display one frame. Repainting doesn't seem to solve this. I have also tried using the wait command to give the UserForm a few seconds to fully load before the main macro code runs, but this does not resolve the issue either.

Is there a way to get around this issue or is it simply impossible to have an animated UserForm displaying while a macro runs in the background?

[romperstomper]

Is it not suitable for a simple progress bar rather than an animated gif?

[Equilibrium31]

While a progress bar could work for this particular project, I am hoping to apply the method of using an animated UserForm to another project where the length of time that a macro takes to run varies greatly depending on some loops and size of files being imported.