Link to home
Start Free TrialLog in
Avatar of tina2009
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.
possible?
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

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
This may be more what you want
animated_gif.xlsm
Avatar of tina2009
tina2009

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
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
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
tks
Pleased to help