SHOW a gif animated when i click on a buton in userform ...

tina2009
tina2009 used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Roy CoxGroup Finance Manager

Commented:
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
Roy CoxGroup Finance Manager

Commented:
This may be more what you want
animated_gif.xlsm

Author

Commented:
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
Introduction to R

R is considered the predominant language for data scientist and statisticians. Learn how to use R for your own data science projects.

Roy CoxGroup Finance Manager

Commented:
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.
Group Finance Manager
Commented:
Is this what you mean
animated_gifi-ex-2-.xlsm

Author

Commented:
tks
Roy CoxGroup Finance Manager

Commented:
Pleased to help

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial