SHOW a gif animated when i click on a buton in userform ...
i need to show a gif animation during the code in a click event of a button in a useform is complete, and not permit the user to click in other controll do until the code in the button not is complete, then hide the gif animation return free all component in the userform.
possible?
Microsoft Excel
Last Comment
Roy Cox
8/22/2022 - Mon
Roy Cox
This is an example of using a webbrowser control to display an animated gif. it's based on an example that I made years ago, I've left all the code in in case you need it. If you want to use it post back for help adapting it web_browser.xlsm
no...
psedudo code:
- i click on button1 on userform1
-show the gif animation in front of userform1(in a little userform2, i think)
-lock all controll in userform1
-code in button1 is finished, close the little userform with animation
-then remake free all controll in userform1
my idea is to lock all controll when i click on button do until code in button is finished.
any and other idea area welcome
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
Roy Cox
My example shows the gif whilst the code is running so no other controls can be used. It's all in one userform which is what your first post seemed to want. You can use a separate userform ith the gif, but simply hide the main form.
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.