Learn to Build a Decision Wheel with an Excel Spreadsheet using VBA Visual Basic

แชร์
ฝัง
  • เผยแพร่เมื่อ 20 ก.ย. 2024

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

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

    I saw a couple other videos doing this same process and it was so much more difficult to figure out. This was simple to use and it’s going to reshape my program for classes. Thank you!

  • @Steve-mo4qp
    @Steve-mo4qp ปีที่แล้ว

    Phenomenal. So clear and easy (apart form a few of my own mistakes along the way). This is going to morph in so many ways for our Maths classes. Thankyou Thankyou

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

    Awesome stuff as always

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

    Hiya, I'm trying to do this on mac so the kernel132 isn't going to work on my end (to my knowledge) any idea of what I can do here?

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

    If you don't want to build this or have trouble, you can get this tool here: www.etsy.com/DigitalMelon/listing/800679258/decision-wheel-in-excel-spreadsheet-in
    For more info on Excel Dashboards, check out my video course at www.DashboardsByJoe.com
    I go step by step over 50 videos and 7 hours from data to dashboard. I use short videos to keep attention and go over getting the Data, making the Pivot tables and Charts, Making interactive with Slicers and putting together on the dashboard.

  • @stanislavjohnson3605
    @stanislavjohnson3605 7 หลายเดือนก่อน

    love it, thank you, but something is not quite right, wheel always ends up in the same place, not sure why though

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

    My pie chart is so big that the names overlay one another, it would be cool if the winner name was highlighted on the column

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

    Great video thank you so much but i do have one big issue. I want to add some graphics on the wheel but when it spins it stays in their place and not spin. How do i get the graphics to spin with the wheel

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

    Can someone help me understand what "kernel32" is suppose to be addressing? Every time I go to run the macro it says that that "file isn't found?" Any help would be great, thank you.

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

      Same, any luck solving it?

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

      #If VBA7 Then
      Private Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal millisecs As LongPtr)
      #Else
      Private Declare Sub Sleep Lib "kernel32" (ByVal millisecs as Long)
      #End If
      When you change the second Declare statement, Visual Basic for Applications 7.0 will report an error that indicates that you have to use PtrSafe. However, the report is incorrect because the line is in a section that only runs in Visual Basic for Applications 6.0. VBA 6.0 does not use PtrSafe. Therefore, you can safely ignore the error message.

  • @garyu6995
    @garyu6995 9 หลายเดือนก่อน

    Mine stops at the same place always????? How do I do that?

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

    Hello i do this on 2007 excel version the sleep code keep saying its error and then if i delete sleep the wheel was not stopping to it's spin.

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

    do you know how to select the Nth row ie D5:P5 where N is a random number in column A

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

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

    I got a question is this possible to convert into prediction as in daily fantasy sports based on matchups dvp fantasy points etc if so I would love to see a video and or instructions

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

      Hi. Yeah you could convert it to something for DFS but it would be a little time consuming to get results. I mean you could put the expected outcomes in a wheel and spin it but it would take awhile to enter the choices and run the simulation. if doing a lot of DFS options, Id do more of a monte carlo simulation but if you had just s few things like picking the winners of games or smaller DFS choices, then it could be done. Ill take a note to possibly make one at some point.