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

  • @rajendersingh1133
    @rajendersingh11334 жыл бұрын

    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.

  • @albanoteles4924
    @albanoteles49244 жыл бұрын

    Top! You are the BEST!!!!!!!!

  • @nullhas
    @nullhas4 жыл бұрын

    Just an another masterpiece from excel master PK.. 👍👍👍

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

    Thanks for your valuable feedback

  • @pgkannan
    @pgkannan4 жыл бұрын

    Thanks PK worth for watching entire video. Thank you so much for your efforts.

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

    Thanks for your valuable feedback

  • @paulocezardesouzasouza2044
    @paulocezardesouzasouza20444 жыл бұрын

    50/5000 For few people creativity has no limits.

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

    Thanks for your valuable feedback.

  • 4 жыл бұрын

    wow, thats amazing sir. its very inspiring. thanks for sharing with us such a great working

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

    Thanks for your valuable feedback

  • @romlef526
    @romlef5264 жыл бұрын

    Hello It's surprising to see that !!! it's really good thank you, always so good your videos, I love

  • @AshutoshKumar-pd5id
    @AshutoshKumar-pd5id4 жыл бұрын

    your tutorial is very nice.

  • @NeangBona
    @NeangBona4 жыл бұрын

    I really like your video so much thank you for sharing such an amazing file PK.

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

    Thanks for your valuable feedback

  • @MohAboAbdo
    @MohAboAbdo4 жыл бұрын

    Thank You So Much,Sir.

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

    Welcome

  • @NR-mh9zj
    @NR-mh9zj4 жыл бұрын

    Amazing. Ur expert 👍

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

    Thanks for your valuable feedback

  • @josepacheco8554
    @josepacheco85543 жыл бұрын

    Sensacional!

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Obrigado pelo seu feedback valioso

  • @anirbansarkar7391
    @anirbansarkar73914 жыл бұрын

    Hi PK, you are amazing, please let me know do you provide online classes also... I am very much interested 😊

  • @rajendersingh1133
    @rajendersingh11334 жыл бұрын

    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🙏

  • @mr.grumps7835
    @mr.grumps78353 жыл бұрын

    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

  • @ayaanansari4765
    @ayaanansari47654 жыл бұрын

    It so amazing and wonderful

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

    Thanks for your valuable feedback

  • @thecalipercnc2800
    @thecalipercnc28003 жыл бұрын

    ITS AMAZING WORK

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback

  • @emrahakyildiz3655
    @emrahakyildiz36554 жыл бұрын

    very nice shares. Thanks.

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

    Thanks for your valuable feedback

  • @surendraramcharan2756
    @surendraramcharan27564 жыл бұрын

    absolutely brilliant, you make excel look so easy.

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

    Thanks for your valuable feedback

  • @sujeetvichare5825

    @sujeetvichare5825

    4 жыл бұрын

    Cannot see clearly

  • @sujeetvichare5825

    @sujeetvichare5825

    4 жыл бұрын

    Very easy to make

  • @sharvari.s.vichare

    @sharvari.s.vichare

    3 жыл бұрын

    Link is under description box

  • @xvzw
    @xvzw14 күн бұрын

    can I control the result?

  • @vivekmusafir4492
    @vivekmusafir44924 жыл бұрын

    Certainly impressive... however I would love to see pratical utility of this masterpiece...

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

    Thanks for your valuable feedback

  • @rajkumarrajan8059
    @rajkumarrajan80594 жыл бұрын

    Fantastic

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

    Thanks for your valuable feedback

  • @samuelmundia320
    @samuelmundia3204 жыл бұрын

    Thanks..

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

    Welcome

  • @HealthyVibes
    @HealthyVibes3 жыл бұрын

    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

  • @bssgiridhar
    @bssgiridhar11 ай бұрын

    Wow super

  • @PKAnExcelExpert

    @PKAnExcelExpert

    11 ай бұрын

    Thank you so much

  • @ashutoshpatel19
    @ashutoshpatel194 жыл бұрын

    Very nice tips Sir VBA me vlookup and sumifs ka other workbook ka tutorial chahiye

  • @viduraacademy4101
    @viduraacademy41012 жыл бұрын

    amazing

  • @PKAnExcelExpert

    @PKAnExcelExpert

    2 жыл бұрын

    Thanks

  • @saahilagarwal8248
    @saahilagarwal82482 жыл бұрын

    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.

  • @christophergwaltney6294
    @christophergwaltney62943 жыл бұрын

    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

  • @DM-YouTube
    @DM-YouTube4 жыл бұрын

    👌👍😀

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

    Thanks for your valuable feedback

  • @kennylefebvre6158
    @kennylefebvre61586 ай бұрын

    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

    @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

  • @akashdange9281
    @akashdange92814 жыл бұрын

    Nice video

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

    Thanks for your valuable feedback

  • @coldbluemptybottle
    @coldbluemptybottle2 жыл бұрын

    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.

  • @careeredgeschool
    @careeredgeschool3 жыл бұрын

    wow so amazing all ur Video and how can be like u

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback

  • @winnieyang413
    @winnieyang4132 жыл бұрын

    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?

  • @user-hn6xt3fg4l
    @user-hn6xt3fg4l2 жыл бұрын

    من فضلك ممكن تحميل البرنامج .. وان تكون الترجمة متاحة بالعربية على فيديوهاتك 👍👌مهتم ومتابع من الجزائر 🇩🇿

  • @PKAnExcelExpert

    @PKAnExcelExpert

    2 жыл бұрын

    تم توفير رابط التنزيل في مربع وصف الفيديو أو قم بزيارة موقعنا على الويب WWW.PK-AnExcelExpert.Com. الترجمة باللغة العربية غير متوفرة حتى الآن.

  • @shivdeshOfficial3099
    @shivdeshOfficial30994 жыл бұрын

    Sir how to create mid reports

  • @AshutoshKumar-pd5id
    @AshutoshKumar-pd5id4 жыл бұрын

    Sir, VBA me Otherworkbook se vlookup and Sumifs, and countifs ka video banaiye plz

  • @waseemali433
    @waseemali4334 жыл бұрын

    Nice video, I don't understand why sir does not take classes

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

    Thanks for your valuable feedback. I am a full time employee in an MNC. Creating the KZread videos in part time only

  • @omkarpatil695
    @omkarpatil6954 жыл бұрын

    Where we can use this?

  • @PowerExbyJitendra

    @PowerExbyJitendra

    4 жыл бұрын

    Please see my 1st video to know answer of this question.

  • @AshutoshKumar-pd5id
    @AshutoshKumar-pd5id4 жыл бұрын

    sir vba worksheet function me sumifs and vlookup other workbook ka video create kijiye

  • @shivannahr780
    @shivannahr7804 жыл бұрын

    Very nice sir Dear sir please invoice how to create Next video please help me sir

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 жыл бұрын

    Thanks for your valuable feedback. I will definitely try to make such video very soon

  • @garrett5386
    @garrett53863 жыл бұрын

    I'm getting an error: "compile error : duplicate declaration in current scopre"

  • @alexeyyatvetskiy5269

    @alexeyyatvetskiy5269

    3 жыл бұрын

    I have the same issue, unfortunately

  • @kennylefebvre6158

    @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

    @garrett5386

    6 ай бұрын

    @@kennylefebvre6158 lol I don’t even remember what I used this for 😂

  • @mechboy1769
    @mechboy17692 жыл бұрын

    Sir create a roulette wheel ...

  • @mssmith8213
    @mssmith82133 жыл бұрын

    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

    @mssmith8213

    3 жыл бұрын

    for the "Spin Wheel"

  • @kennylefebvre6158

    @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

  • @wateryshoes667
    @wateryshoes667 Жыл бұрын

    How to display winner's name in a box or cell?

  • @PKAnExcelExpert

    @PKAnExcelExpert

    Жыл бұрын

    we need to add one more piece of code. I will try to create a saperate video on this topic

  • @wateryshoes667

    @wateryshoes667

    Жыл бұрын

    @@PKAnExcelExpert so it is possible? I thought Excel cannot know on which piece of the wheel the arrow is pointing.

  • @joses.pacheco3069
    @joses.pacheco30693 жыл бұрын

    Sensacional!

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback

  • @saahilagarwal8248
    @saahilagarwal82482 жыл бұрын

    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.