Skip to content

Used to demonstrate how VBA can be integrated with 3D shapes to deliver smooth and simple animations within Excel.

License

Notifications You must be signed in to change notification settings

GithubUserAccountAmazing/Random-Number-3D-Wheel-in-Excel

Repository files navigation

Random-Number-3D-Wheel-in-Excel 📗

This project demonstrates the creative use of VBA to animate 3D shapes in Excel. I created a 3D wheel with 12 segments; the wheel spins and slows down to randomly stop at a selected segment, which flashes green to indicate the winner. The spinning duration varies each spin, adding suspense and excitement to the animation. This project showcases my skills and creativity in using Excel beyond its conventional functions.

theamazingspinningwheel


Build Instructions
    1. Import ThisWorkbook.cls and randomWheel.bas into theAmazingSpinningWheel.xlsx
    2. If you wish to archive your results: set archiveDir in randomWheel.bas to the directory you wish to save ArchiveResults.csv
    3. Right click on the wheel and assign macro to either 'archiveruns' or 'spinWheel'
    4. Save file as theAmazingSpinningWheel.xlsm and close file.

For best results run the following via command prompt or through a shortcut:
    "C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE" /e /x "C:\Path\to\theAmazingSpinningWheel.xlsm"

The following is data retrieved using archivereader.bas after performing 500 archived runs.
    Values      1	2	3	4	5	6	7	8	9	10	11	12

    Totals	50	42	29	47	49	35	52	45	53	32	31	35
               
               Average:	42	
    Standard Deviation:	8	

Releases

No releases published

Packages

No packages published