I am trying get a brief run once animation for a game project. Even when I save the GIF with the properties to only loop once, I still get a continuous loop when implementing it to the userform for this function. An additional frustration is that from my tinkering I have yet to find a way to make the userform end after running the one time loop. I have tried a few different VBA scripts that cause the code to wait a certain amount of time but they always seem to trigger after I close the userform and don't actually stop the previously mentioned continuous loop.
Ideal Summary:
I want to be able to click on an image with an assigned macro (custom buttons) that will create a pop up GIF to run once before closing itself. Another option would be that it runs after a certain cell reaches a specific value but again only once instead of continuous.
Bonus Problem: **Much less important**
I am looking for a good code to perform a bit of error wrapping for errors 7 and 13. It would be great if the code triggered a .bat file to map out network drives and fix the error right away but due to obvious security issues it may be best to have a wrapper that offers the option to either run that .bat file or end the debug and run without that file look up.
Ideal Summary:
I want to be able to click on an image with an assigned macro (custom buttons) that will create a pop up GIF to run once before closing itself. Another option would be that it runs after a certain cell reaches a specific value but again only once instead of continuous.
Bonus Problem: **Much less important**
I am looking for a good code to perform a bit of error wrapping for errors 7 and 13. It would be great if the code triggered a .bat file to map out network drives and fix the error right away but due to obvious security issues it may be best to have a wrapper that offers the option to either run that .bat file or end the debug and run without that file look up.
