Dynamic Spin Wheel in Excel
#SpinWheel #Userform
Hello Friends,
In this video, you will learn how to create a dynamic spin wheel in Excel. We have used the Pie Chart to create the spin wheel and VBA user form to manage the name on spin wheel dynamically.
Download the practice file from below given link:
www.pk-anexcelexpert.com/dyna...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
WWW.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Pinterest:
/ pkanexcelexpert
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-matic.com/refer/...
Пікірлер: 84
Your best thing is that everyone can download any of your Excel files, And I am your biggest fan from India. I watches every video of you sir.
Top! You are the BEST!!!!!!!!
Just an another masterpiece from excel master PK.. 👍👍👍
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Thanks PK worth for watching entire video. Thank you so much for your efforts.
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
50/5000 For few people creativity has no limits.
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback.
wow, thats amazing sir. its very inspiring. thanks for sharing with us such a great working
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Hello It's surprising to see that !!! it's really good thank you, always so good your videos, I love
your tutorial is very nice.
I really like your video so much thank you for sharing such an amazing file PK.
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Thank You So Much,Sir.
@PKAnExcelExpert
4 жыл бұрын
Welcome
Amazing. Ur expert 👍
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Sensacional!
@PKAnExcelExpert
3 жыл бұрын
Obrigado pelo seu feedback valioso
Hi PK, you are amazing, please let me know do you provide online classes also... I am very much interested 😊
Sir you makes such good videos.I see a lot of Excel video, but your videos amazing... The compliment you as is as low as you have. Sir could you please teach me??? I want to be like you too. Please sir🙏
Can I please confirm that this is for 32bit and not 64bit? The reason I ask is because the code does not seem to allow the wheel to spin freely like in your video only in the defined increments despite the vba.doevent. Please advice
It so amazing and wonderful
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
ITS AMAZING WORK
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
very nice shares. Thanks.
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
absolutely brilliant, you make excel look so easy.
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
@sujeetvichare5825
4 жыл бұрын
Cannot see clearly
@sujeetvichare5825
4 жыл бұрын
Very easy to make
@sharvari.s.vichare
3 жыл бұрын
Link is under description box
can I control the result?
Certainly impressive... however I would love to see pratical utility of this masterpiece...
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Fantastic
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Thanks..
@PKAnExcelExpert
4 жыл бұрын
Welcome
Hey, i have a question. I'm doing a promotion giveaway where every customer who purchases something gets to spin the wheel to reveal a special promotion offer. But is there any way to ensure that the customer only gets 1 spin in order to prevent cheating and multiple tries? Is there also a way to link their result to a different excel etc? Just so i know they are not spinning more than once and they are not cheating
Wow super
@PKAnExcelExpert
11 ай бұрын
Thank you so much
Very nice tips Sir VBA me vlookup and sumifs ka other workbook ka tutorial chahiye
amazing
@PKAnExcelExpert
2 жыл бұрын
Thanks
Hi sir, I want to insert a earth image and rotate. I have ms office 7. I need to rotate an earth image in excel with the help of button. Is it possible in excel ? thank you.
Hello friend I want to make a water wheel simulator to display excel spreadsheet calculations such as if flow into wheel is 1 l/s it shall spin at 1 rotation per secons or such as that, can you help
👌👍😀
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Hello PK, I followed this video to a "T" and Im coming up with an error "duplicate declaration in current scope". I see a few others have had the same issue however im not seeing any answer on how to fix it. I tried researching how and it told me to go under tools and select preferences however when I go to do that it wont let me select that either. Can you please help me? thanks,
@davidowens3409
5 ай бұрын
Having the same issue here. Happens after adjusting the spin range and speed at around the 16 minute mark of video. Thank you
Nice video
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Hi sir can you make a tutorial on how create animation of a rolling number, range let's say from 0-9 then stops after some time then display the randomly picked number.
wow so amazing all ur Video and how can be like u
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
How to do a selection with multiple winner? And auto save the winners name? For example, prize 3, 10 winners, so once we draw for prize 3, the 10 winners will prompted on the screen then can auto save in file + auto remove the names from the draw list?
من فضلك ممكن تحميل البرنامج .. وان تكون الترجمة متاحة بالعربية على فيديوهاتك 👍👌مهتم ومتابع من الجزائر 🇩🇿
@PKAnExcelExpert
2 жыл бұрын
تم توفير رابط التنزيل في مربع وصف الفيديو أو قم بزيارة موقعنا على الويب WWW.PK-AnExcelExpert.Com. الترجمة باللغة العربية غير متوفرة حتى الآن.
Sir how to create mid reports
Sir, VBA me Otherworkbook se vlookup and Sumifs, and countifs ka video banaiye plz
Nice video, I don't understand why sir does not take classes
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback. I am a full time employee in an MNC. Creating the KZread videos in part time only
Where we can use this?
@PowerExbyJitendra
4 жыл бұрын
Please see my 1st video to know answer of this question.
sir vba worksheet function me sumifs and vlookup other workbook ka video create kijiye
Very nice sir Dear sir please invoice how to create Next video please help me sir
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback. I will definitely try to make such video very soon
I'm getting an error: "compile error : duplicate declaration in current scopre"
@alexeyyatvetskiy5269
3 жыл бұрын
I have the same issue, unfortunately
@kennylefebvre6158
6 ай бұрын
Did you ever get an answer to this because Im getting the same thing and I can't get around it. Thanks
@garrett5386
6 ай бұрын
@@kennylefebvre6158 lol I don’t even remember what I used this for 😂
Sir create a roulette wheel ...
How can I correct this error? "compile error : duplicate declaration in current scope" It is under Sub Spin () at the 5th set "Dim sh As Worksheet"
@mssmith8213
3 жыл бұрын
for the "Spin Wheel"
@kennylefebvre6158
6 ай бұрын
Did you ever get an answer to this because Im getting the same thing and I cant seem to get around it. Thanks
How to display winner's name in a box or cell?
@PKAnExcelExpert
Жыл бұрын
we need to add one more piece of code. I will try to create a saperate video on this topic
@wateryshoes667
Жыл бұрын
@@PKAnExcelExpert so it is possible? I thought Excel cannot know on which piece of the wheel the arrow is pointing.
Sensacional!
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Hi sir, I want to isert a earth image and rotate. I have ms office 7. I need to rotate an earth image in excel with the help of button. Is it possible in excel ? thank you.