Dynamic Spin Wheel in Excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 7 ก.พ. 2025
  • #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-anexcel...
    Download our free Excel utility Tool and improve your productivity:
    www.pk-anexcel...
    See our Excel Products:
    www.pk-anexcel...
    Visit to learn more:
    Chart and Visualizations: www.pk-anexcel...
    VBA Course: www.pk-anexcel...
    Download useful Templates: www.pk-anexcel...
    Dashboards: www.pk-anexcel...
    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-AnExcel...
    Facebook:
    / pkanexcelexpert
    Telegram:
    t.me/joinchat/...
    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-m...

ความคิดเห็น • 86

  • @rajendersingh1133
    @rajendersingh1133 4 ปีที่แล้ว +4

    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.

    • @gb6336
      @gb6336 5 หลายเดือนก่อน

      no IM his biggest from india

  • @pgkannan
    @pgkannan 4 ปีที่แล้ว +1

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

  • @paulocezardesouza50
    @paulocezardesouza50 4 ปีที่แล้ว +1

    50/5000
    For few people creativity has no limits.

  • @nullhas
    @nullhas 4 ปีที่แล้ว +3

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

  • @andessta1
    @andessta1 6 วันที่ผ่านมา

    very nice, but what if the spin can display the selected name and place it in a certain cell

  • @albanoteles4924
    @albanoteles4924 4 ปีที่แล้ว

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

  • @NeangBona
    @NeangBona 4 ปีที่แล้ว +1

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

  • @NR-mh9zj
    @NR-mh9zj 4 ปีที่แล้ว +1

    Amazing. Ur expert 👍

  •  4 ปีที่แล้ว +3

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

  • @emrah2321
    @emrah2321 4 ปีที่แล้ว +1

    very nice shares. Thanks.

  • @AshutoshKumar-pd5id
    @AshutoshKumar-pd5id 4 ปีที่แล้ว

    your tutorial is very nice.

  • @romlef526
    @romlef526 4 ปีที่แล้ว

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

  • @kennylefebvre6158
    @kennylefebvre6158 ปีที่แล้ว +1

    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 ปีที่แล้ว

      Having the same issue here. Happens after adjusting the spin range and speed at around the 16 minute mark of video. Thank you

  • @bssgiridhar
    @bssgiridhar ปีที่แล้ว +1

    Wow super

  • @MohAboAbdo
    @MohAboAbdo 4 ปีที่แล้ว +2

    Thank You So Much,Sir.

  • @xvzw
    @xvzw 7 หลายเดือนก่อน +1

    can I control the result?

  • @rajkumarrajan8059
    @rajkumarrajan8059 4 ปีที่แล้ว +1

    Fantastic

  • @anirbansarkar7391
    @anirbansarkar7391 4 ปีที่แล้ว +1

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

  • @rajendersingh1133
    @rajendersingh1133 4 ปีที่แล้ว

    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🙏

  • @thecalipercnc2800
    @thecalipercnc2800 4 ปีที่แล้ว +1

    ITS AMAZING WORK

  • @عبدالسلامبنعباس
    @عبدالسلامبنعباس 2 ปีที่แล้ว +1

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

    • @PKAnExcelExpert
      @PKAnExcelExpert  2 ปีที่แล้ว

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

  • @viduraacademy4101
    @viduraacademy4101 2 ปีที่แล้ว

    amazing

  • @ayaanansari4765
    @ayaanansari4765 4 ปีที่แล้ว +2

    It so amazing and wonderful

  • @akashdange9281
    @akashdange9281 4 ปีที่แล้ว +1

    Nice video

  • @surendraramcharan2756
    @surendraramcharan2756 4 ปีที่แล้ว +4

    absolutely brilliant, you make excel look so easy.

  • @careeredgeschool
    @careeredgeschool 4 ปีที่แล้ว +1

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

  • @mr.grumps7835
    @mr.grumps7835 4 ปีที่แล้ว +1

    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

  • @josepacheco8554
    @josepacheco8554 4 ปีที่แล้ว +1

    Sensacional!

  • @ashutoshpatel19
    @ashutoshpatel19 4 ปีที่แล้ว

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

  • @vivekmusafir4492
    @vivekmusafir4492 4 ปีที่แล้ว +2

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

  • @DM-YouTube
    @DM-YouTube 4 ปีที่แล้ว +1

    👌👍😀

  • @saahilagarwal8248
    @saahilagarwal8248 3 ปีที่แล้ว

    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.

  • @samuelmundia320
    @samuelmundia320 4 ปีที่แล้ว +1

    Thanks..

  • @winnieyang413
    @winnieyang413 3 ปีที่แล้ว

    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?

  • @waseemali433
    @waseemali433 4 ปีที่แล้ว +1

    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 TH-cam videos in part time only

  • @christophergwaltney6294
    @christophergwaltney6294 4 ปีที่แล้ว

    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

  • @HealthyVibes
    @HealthyVibes 3 ปีที่แล้ว

    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

  • @shivannahr780
    @shivannahr780 4 ปีที่แล้ว +1

    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

  • @coldbluemptybottle
    @coldbluemptybottle 3 ปีที่แล้ว

    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.

  • @garrett5386
    @garrett5386 4 ปีที่แล้ว +3

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

    • @alexeyyatvetskiy5269
      @alexeyyatvetskiy5269 4 ปีที่แล้ว +4

      I have the same issue, unfortunately

    • @kennylefebvre6158
      @kennylefebvre6158 ปีที่แล้ว

      Did you ever get an answer to this because Im getting the same thing and I can't get around it. Thanks

    • @garrett5386
      @garrett5386 ปีที่แล้ว

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

  • @shivdeshOfficial3099
    @shivdeshOfficial3099 4 ปีที่แล้ว

    Sir how to create mid reports

  • @AshutoshKumar-pd5id
    @AshutoshKumar-pd5id 4 ปีที่แล้ว

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

  • @AshutoshKumar-pd5id
    @AshutoshKumar-pd5id 4 ปีที่แล้ว

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

  • @omkarpatil695
    @omkarpatil695 4 ปีที่แล้ว

    Where we can use this?

    • @PowerExbyJitendra
      @PowerExbyJitendra 4 ปีที่แล้ว

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

  • @mechboy1769
    @mechboy1769 3 ปีที่แล้ว

    Sir create a roulette wheel ...

  • @mssmith8213
    @mssmith8213 3 ปีที่แล้ว

    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 ปีที่แล้ว

      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 2 ปีที่แล้ว

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

    • @PKAnExcelExpert
      @PKAnExcelExpert  2 ปีที่แล้ว +1

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

    • @wateryshoes667
      @wateryshoes667 2 ปีที่แล้ว

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

  • @joses.pacheco3069
    @joses.pacheco3069 3 ปีที่แล้ว

    Sensacional!

  • @saahilagarwal8248
    @saahilagarwal8248 3 ปีที่แล้ว

    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.