PowerPoint Quiz Using VBA
Create an Interactive Quiz using PowerPoint and VBA

Included in this download is …

  1. Full Lesson Plan
  2. Starter Activity Worksheet
  3. VBA_Quiz_START which should be made available to students at the beginning of the lesson
  4. VBA_Quiz_SlideShow_MACRO is the lesson presentation detailing each step of the Quiz
  5. VBA_Quiz_Code_WS is a support worksheet for students who are struggling with the task (full code)
  6. VBA_Quiz_FINAL is a completed VBA Quiz with a name request, 3 questions and a results page
Fun and Informative Lesson …

I have delivered this lesson multiple times and it is always a popular activity, with students able to choose their own quiz topic and design their own questions. Most of the time this activity has stretched over 2 lessons, allowing students who struggle with coding to catch-up, whilst the more gifted students are able to develop and enhance their quiz.

Save for later
  • VBA_Quiz_Code_WS.docx
  • VBA_Quiz_FINAL.pptm
  • VBA_Quiz_Lesson_Plan.docx
  • VBA_Quiz_SlideShow_MACRO.pptm
  • VBA_Quiz_START.pptm
  • VBA_Quiz_Starter_Task.docx

About this resource


Created: Jul 12, 2019


docx, 977 KB


Game, puzzle, quiz

pptm, 244 KB


Lesson plan

docx, 38 KB


Report a problem

Tes Paid Licence

How can I re-use this?