Do you need to randomly select someone from your department to win a prize? This awesome free macro from Rob Collie at PowerPivotPro.com will do the trick. Download for free from: http://mrx.cl/spinwheel20

Rob had an idea of how to improve participation on his company Zoom calls. He wanted a way to randomly call on a person. I knew it was going to be a fun day when Rob called and said, “do you think you can rotate the Excel Camera Tool?” He explained what he was trying to do and both of us spent way too much time trying to tweak the workbook to have a spinning Wheel of Inquisition.

We kept adding new features so the wheel would spin faster at first and then slow down. Rob added the ability to mark someone as absent from the call and the ability to add a fudge factor to award someone with a higher probability of being chosen.

Rob took my lame spinning arrow and made it look like a pro app, just like he and his team do with Power BI dashboards at PowerPivotPro.

Table of Contents
(0:00) I get a call from Rob Collie about a spinning carnival wheel in Excel
(0:40) Inserting an arrow shape and making it spin
(1:15) Looking at the VBA Code
(2:23) Rob’s version of the spinning wheel
(3:40) How to download
(3:50) Call Rob for help with your Power BI projects