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.
possible?
possible?
Microsoft Excel
Last Comment
Roy Cox
This may be more what you want
animated_gif.xlsm
animated_gif.xlsm
ASKER
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
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
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.
ASKER CERTIFIED SOLUTION
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
or
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 questionASKER
tks
Pleased to help
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
web_browser.xlsm