Creating Loading Effect in User Forms

Randolph

New Member
Joined
Jun 19, 2015
Messages
27
Hello Guys.

I created a user Form that takes some data and then shows winners in a label for an item each time an item is picked.
Basically what I want is to know how I can create some sort of loading effect on a label before showing the result.

If there is any other way to do it I would appreciate it.

Maybe I can use another sheet with buttons ... instead of a user form.
But I really would love to use a user form to do this.

So if anyone knows how to create a cool loading / buffering effect let me know.

Thanks.

The Forms Looks like This

------------------------------------------------------
--------------------ITEM NAME---------------------
------------------------------------------------------
------------------------------------------------------
-----Get Items----Get Winners----Next Item------
------------------------------------------------------
------------------------------------------------------
-----1st person-------------------------------------
------------------------------------------------------
-----2nd person-------------------------------------
------------------------------------------------------
-----3rd person-------------------------------------
------------------------------------------------------

So Item Name is a label, Get Items, Get Winners and Next Item are buttons.
Bellow we have 3 labels. So I want a loading effect when the Get Winners button is being clicked.
The labels are populated from a sheet which generates results.
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
I don't know exactly what kind of effects you are looking for, but I've found some cool things from Google when trying to make QR Codes, a snake game, and mouse trails. Try looking there and look at their (very complex) codes.
 
Upvote 0

Forum statistics

Threads
1,223,270
Messages
6,171,102
Members
452,379
Latest member
IainTru

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top