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