Who wants to be a millionaire? - two-player Excel VBA version


Or if you'll excuse a pun - Who wants to VBA-millionaire.

In the depths of the first COVID lockdown in April 2020, pub quizzes on Zoom were as good as it got. When my turn to host came around, I combined the popular UK quiz game show with the versatility of Excel VBA macros and user forms to make this game.

You can download the game here, and be the Chris Tarrant of your group of friends by pitting two teams against each other. The game feeds off two sets of 15 questions that get more difficult as the game goes on - the game instructions provided explain how you can customise these questions away from my (slightly non-PC) defaults.

  1. Download the ZIP file from the link above.
  2. Extract both files contained in the ZIP to the same folder.
  3. Open the .xlsm file on a PC with Excel/Office 365 installed and Windows Media Player installed (if you wish to play the audio for authentic ITV suspense).
  4. Follow the instructions provided to run the game.
  5. Enjoy playing - optionally as a drinking game where each member of the team has to down a shot everytime the opposite team hits the £1000, £32000 or £1M milestones. (Escalate the % alcohol content of the shot consumed for each milestone.)