Avatar of tina2009
 asked on

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.
Microsoft Excel

Avatar of undefined
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
Roy Cox

This may be more what you want

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.
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.
Roy Cox

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
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.
ask a question

Roy Cox

Pleased to help
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.