Make PowerPoint Quiz Game - Grade & Percentage, Report Card - Trigger Animations | PPT VBA Tutorial

I haven't explained "CalculateResult" Macro in the video, the code snippet is seen for a brief second at 8:52.
However, you can Copy-Paste the CODE from my website: pptvba.com/quiz-game-percentage/
How to make PowerPoint Interactive Quiz Game with Report Card - Calculate Grade & Percentage in PowerPoint Quiz Game Tutorial
DOWNLOAD THIS POWERPOINT QUIZ GAME TEMPLATE FOR FREE: pptvba.com/quiz-game-percentage/
VBA CODE: pptvba.com/quiz-game-percentage/
Download Premium File: pptvba.com/download-powerpoin...
This Ultimate Powerpoint Quiz Game template is the perfect tool for anyone who wants to make customised quizzes in a short time. Already downloaded by multiple innovative teachers and HR Managers world wide, the quiz template is perfect for classes, competitions, team building, and even for fun activities. Add interactivity and healthy competition to your classroom today!
Import your questions and answers from an excel sheet with just one button. Making an interactive PowerPoint quiz couldn't be easier!
Randomly shuffle the multiple-choice questions and give each team a time limit with the countdown timer. With those simple steps, your ppt quiz is ready to play!
Your students will be delighted by the sound and visual effects on each, and get a detailed, automatically generated scorecard at the end.
The organiser also gets an excel sheet with performance analysis of each participant. To top it off, a customisable print ready certificate is created for every person who finishes the quiz game.
The Ultimate Powerpoint Quiz Game is an easy and fun way to engage your team and encourage competition and growth. The automated template will save lots of your time, and you won't have to edit each individual slide ever again!
Features:
Ease of use:
With this template, you'll have a quiz ready faster than you could say "The Ultimate Powerpoint Quiz Game template". Simply follow these two steps:
Type your multiple choice questions and answers in excel
Press "import" in PowerPoint
Et voila! The codes will do all the magic and work, creating a beautiful animated quiz for you in just minutes! No more hours spent in creating a quiz, no more having to use arcane quizzing websites or technology.
Customised feedback
After finishing the quiz, each of your students gets a report card that details their grade, points, percentage, and number of right and wrong answers. All the feedback they need to keep improving and learning!
You also get an excel sheet that details every person's score, saving you the effort of correcting each answer individually!
Fun and efficient:
This PowerPoint quiz template is packed with animations, visual indicators, and sound effects. Your students won't believe that this quiz is made in PowerPoint!
Each one of them also gets a certificate at the end of the quiz to celebrate their hard work! The certificate is automatically generated for each student and comes print ready so they can show it off with pride.
Free extra features!:
Want to conduct an online exam in PowerPoint? Using this template you can set a custom time limit for each student!
Worried that people will share their answers? Shuffle the questions for each participant with a single click!
Want everyone to have different questions? This template can import random questions from a question bank too!
Download the Ultimate Powerpoint Quiz Game template now and join the 250+ teachers who have taken their classes to another level and earned the love of their bosses and students!
Import Questions from Excel
Export Quiz Report Card to Google Sheet
Generate and Print Certificate
Result Analysis in Excel (time per question)
Flag Questions for Review
Shuffle Questions
Customizable Countdown Timer Clock
00:00 Introduction
00:49 Design & Layout
01:00 Question Slide
03:29 Result Slide
05:23 Correct/Wrong Answer VBA Code
06:13 Percentage PPT VBA Code
06:53 Grade PPT VBA Code
07:47 Additional PPT VBA Macro Codes
08:53 Calculate Percentage & Grade
09:53 Insert Actions to Shapes
10:52 Animations for Correct/Wrong Answers
13:05 Sound Effects
14:04 Next Question Button
15:01 Add more questions
16:46 Exit Game Button
17:17 Disabling Navigation
17:37 One Attempt per Question
20:00 Testing the game
20:40 Save as .pptm
21:00 Premium Template
EQUIPMENT: This video contains affiliate links. If you click on one of them, I'll receive a commission
💻Laptop: amzn.to/2BvJ1Cp (Dell XPS 15)
🎙Microphone: amzn.to/38jdVtK (Zoom H1n)
💿Software: Camtasia Studio
Intro Music: Dock Rock (Sting) - John Deley and the 41 Players
Outro Music: Yo Picasso - Verified Picasso
#PowerPointGames #PowerPointTutorial #PPTVBA
I also do freelancing, contact me:
🟥 Bhavesh Shaha,
📧 [e-mail]
🌐 www.pptvba.com
🎥 / bhaveshshaha
📷 basicallybhavesh (DMs are open)

[@businessroadmapprogram9232]

Bhavesh is amazing and has helped me create a professional training quiz. He spent time giving me advice to fix some issues I was having. He is fantastic and this tutorial is worth using.

[@PPTVBA]

Thank you very much for your testimonial! Glad to help out!

[@denisejackson2747]

Your tutorials are great. I have updated my training materials.

[@isentropic8279]

This is fantastic, it opens a whole new world of ideas. Thank you!

[@kokilaraj1]

Amazing tutorials. Well explained . Thank you so much.

[@destaadindalestari1120]

Thank you so much!! It's really helping me👍

[@freddybelio6311]

Bro! Eres un GENIO. Yo no hablo inglés, pero explicas tan bien que he logrado hacer mi propio cuestionario utilizando desde ceros tu código y escribiéndolo de línea en línea. Gracias por compartir tus conocimietos

[@PPTVBA]

¡Muchas gracias por tus amables palabras! Puse su comentario a través de Google Translate y estoy muy feliz de leer su amable comentario.

[@lukealmeida-me4cv]

Thanks a million Bhavesh,your inputs are invaluable and is helping me immensely to effectively engage my students.Gr8 job.!!!

[@amanbharti4752]

You are a Master of Powerpoint.

[@neoalltech]

Hi Sir Is there any way to insert multiple image in a shape and resizing it to fit on that shape using VBA

[@guruprivatbahasainggris4496]

Thank youuuuu sooo much. You are so nice. You always answer my queries.... Always be healthy and may success be with you brother...Peace from Indonesia.

[@udayangera]

Great Video !

[@faruqhsj]

Super brilliant helpful step by step illustration ! Very great help for the needy digitally inclined fellow human beings. Thank you so much dear Bhavesh Shaha ! God bless you with a super happy peaceful prosperity !

[@PPTVBA]

Thank you so much for your kind words!

[@maithvipatel415]

You are the king of PowerPoint

[@SmartWayOnlineAcademy]

Thanks Sir....Wonderful video go ahead sir

[@MarisolRamos-1971]

Nuevamente gracias. Muy bien 😊

[@PPTVBA]

¡Deberíamos colaborar algún día en un proyecto de powerpoint!

[@MarisolRamos-1971]

@@PPTVBA Si. Tus trabajos son geniales 😆

[@muizzadalvi7795]

Excellent. 👍👍👍

[@GAMEWORLD_PPT]

Nice Tutorial ✌😉

[@ca.lokenderchauhan2605]

Mind blowing

[@MrJallamann]

Hi! I love your channel. Already helped me make a lot of fun games for my students. I was wondering, I am trying to get the "shuffle answers" sub work for this quiz, but somehow it doesnt work properly. Problem is that the answer boxes shuffles, but the text within the boxes disappears completely or it shuffles into the wrong answer box. Any solutions?

[@ananyakumar4997]

Nice video 🎉🎉🎉

[@lainmiftahusuad3590]

great

[@habibiatthuu7992]

Nice video it was nice

[@imtinansultan6149]

The perfect tutorial with an excellent explanation may God bless you. I wanted to ask: Can this ppt quiz game be exported to apk file and share it to people as android application?

[@PPTVBA]

Hello! Sadly VBA is supported only in Windows and MacOS. We would not be able to export it as an .APK File.

[@4uchannel833]

Amazing.Brother can you make a game (card pair matching )in powerpoint.

[@backhistory9707]

I don't have calculate template that should go when i click the results in macro. Can you help me this? or just I use old Microsoft Office? I'm using MS Office 2016

[@PPTVBA]

The Sub CalculateResult() code is provided in the website, the link is in the pinned comment. If you're talking about the design, it doesn't matter which design you choose. That is your choice. The game will work either ways. It will definitely work in 2016. Not an issue! Also, the template is available for free download on my website too.

[@kukuaakumanyi6473]

I need you to teach me how to write a code for pair match games when a match is made. how to do get it to buzz?

[@nayanarajeshkumarvidyaclas9320]

can you show next video spin the wheel in power point co i can make a game on that .I love you power point game

[@davidstarkey4695]

How can I get this to run as a macro enabled ppshow, it just doesn't run, and I don't want my students to mess with editing the text.

[@PPTVBA]

I'm assuming that a prompt is coming when you open this in ppsm, but you might be clicking on continue, instead of choosing "enable macros".

[@Sjvzn]

Really amazing work Bhavesha. God bless you. Can you tell , pls from where we can download similar templates for school related tbemes

[@PPTVBA]

Thank you very much. I use slidesgo for school related themes.

[@Sjvzn]

@@PPTVBA Thank you. Unable to download the templates

[@BasicallyBhavesh]

If you're referring to the interactive templates of my website, please check your email (spam and promotional folders too) after ordering the template. If it's slidesgo, you'll have to contact them.

[@babooshka3298]

Thank you for sharing this video. The problem I have is I copied the code from your website and pasted it in as instructed worked for correct answer but when I did the same for the wrong answer got Object required (Error 424) wondered if you could help please

[@PPTVBA]

This would imply that there is an issue with the name of the label or shape. Do remember they should be case sensitive. It should be the exact same in the shape name and in the codes. Feel free to download the file sample from my website and cross check too!

[@babooshka3298]

@@PPTVBA Thank you for your very quick reply Bhavesh. I think I may know what the problem could be thanks to you

[@lakshyaagarwal1364]

Can you give a hint of how to make this premium template

[@PPTVBA]

Most of the features that are in the premium features have a corresponding tutorial video on my channel. Feel free to browse through the tutorials of interactive quiz on my website too.

[@rizalmedina3640]

This is the kind of videos that I always wanted to see online. IN all honesty, I wanted to meet and befriend Bhavesh Shaha

[@EEBSadhaSivam]

Haha He's my friend !

[@muizzadalvi7795]

Can we upload our quiz on KZbin by saving in macro enable presentation or macro enable show? How can I share it?

[@PPTVBA]

The PowerPoint Quiz Game can be played and interacted with only in the PowerPoint Application available in Windows and MacOS. You can send the PowerPoint file to your students directly.

[@muizzadalvi7795]

@@PPTVBA Thanks. 👍

[@nobysalma1030]

it does not appear " Calculate Result" when i chose run macro.. Can you tell me how I can fix it please?

[@PPTVBA]

Please check the pinned comment. I unfortunately cut that part accidentally from the video. You have to copy-paste the Sub CalculateResult into your codes. The entire code is present in the website.

[@brunafranco3713]

Hey! I have a doubt: I was replicating your quiz for one of my projects and it seemed to be working. Only issue is that when I put three consecutive wrong answers in the end report only appears 1 wrong answer. Can you please help me? Thank you, Bruna

[@PPTVBA]

Can you please send the file over to me on my email? I can have a look at it.

[@brunafranco3713]

@@PPTVBA hey! unfortunately no because I work in a bank and we cannot share files from corporate banks outside :(

[@PPTVBA]

@@brunafranco3713 Ah, I understand. Would it be possible for you to download the template from my website and use it? The most common errors could be that (maybe) you haven't added the insert > action > mouse click > wrong answer macro to all the shapes? Can you please share the codes that you've typed. If it is copy-pasted from the website, it shouldn't cause any issues, however if any alterations have occurred, do send me the code.

[@brunafranco3713]

@@PPTVBA I solved it! It was a typo done in the vba code I had Ca. Caption instead of WA. Caption :) so happy! Good job!

[@Dafic_1]

чел, спасибо тебе большое

[@pohprinceofhell987]

I try your same code it says run time error 6 overflow and it's not working

[@PPTVBA]

That's an error due to incorrect variable declaration. Please feel free to download the tutorial file available on the website and cross-check. Else, please send your file to my email (available in description of the video) and I can have a look at your error.

[@IamMidoZ]

When I click start game it doesnt go to the next slide

[@PPTVBA]

Enable your macros! If it's enabled, cross check your code, debug it.

[@floresmarieann5614]

can you make a tutorial how to move object in PowerPoint using keyboard....like using the code keydown

[@PPTVBA]

I've noted this down. Will try to make a tutorial on this! Meanwhile a similar tutorial to catch the 'keypress' in VBA would be: kzbin.info/www/bejne/pqfUf4Gtqselaqc

[@TheMessalana]

This is great...but what if I had a quiz with no wrong answers but I still wanted a scorecard. I have tried this and I keep getting the error message: Compile Error, Ambiguous Name detected!

[@PPTVBA]

The error implies that the name of one of your subroutine is same as your label or variable. Changing that would fix the issue. If you didn't have any wrong answers, the best way to proceed would be to just not add the macro for incorrect answers. If errors still persist, feel free to send me the file over email.

[@TheMessalana]

@@PPTVBA Thanks Bhavesh...will try your suggestions...I appreciate that you took the time to answer me.

[@babytacprimo]

Can you teach us how to hide the answer

[@_amniam]

17:35

[@PPTVBA]

I haven't explained "CalculateResult" Macro in the video, the code snippet is seen for a brief second at 8:52. However, you can Copy-Paste the CODE from my website: pptvba.com/quiz-game-percentage/ Download Premium File: pptvba.com/download-powerpoint-quiz-game-templates

[@kazimrahman7499]

Real Programmers Don't need that Explanations....Anyways....thanks..!!

[@seaweishen3708]

I've been facing some issues with the results sometimes it works sometimes it doesnt. I've just emailed you please have a look

[@PPTVBA]

Hi! I've responded to your email! Always make sure that the SlideXX is mentioned properly according to your presentation!

[@divyanshjain4957]

Sir please tell the codes of calculating results

[@PPTVBA]

I haven't explained "CalculateResult" Macro in the video, the code snippet is seen for a brief second at 8:52. However, you can Copy-Paste the CODE from my website: pptvba.com/quiz-game-percentage/

[@divyanshjain4957]

Ok sir Thank you sir

[@maheshg2873]

Unable to download free files

[@PPTVBA]

What is the error that you're facing? After clicking the download button, you'll be asked for your email. Once that is entered, you can download the file from the website directly or you can check your email for the download link. Do check all the folders of your inbox, including spam. Thanks.

[@maheshg2873]

Same page reloads after clicking on download below

[@PPTVBA]

What file are you trying to download? Can you send me the link and your email?

[@maheshg2873]

Got the file thank you

[@dr.seemitrverma622]

Your presentation was excellent. Thank you a ton for sharing. I really really liked it. God bless

[@PPTVBA]

Thank you so much! Free templates are also available on my website! Please do hit the like and subscribe button for the KZbin algorithm. I would greatly appreciate that.

[@mohdfiqri93]

AFTER I FOLLOW ALL YOUR TUTORIAL THERES NO CALCULATE RESULT IN MACRO.. YOUR TUTORIAL NOT COMPLETED SIR.

[@PPTVBA]

I haven't explained "CalculateResult" Macro in the video, the code snippet is seen for a brief second at 8:52. However, you can Copy-Paste the CODE from my website: pptvba.com/quiz-game-percentage/

[@khankhilji574]

Sir percentage and grade don't work But CA and WA work properly give me some solution😭😭😭

[@PPTVBA]

Generally, for issues like these, the name of the ActiveX Element and the codes don't match. Do note that they are supposed to be case-sensitive. You can also download the template from my website.

[@khankhilji574]

@@PPTVBA thank you sir

[@ltnedu.]

SHOW RESULTS -> ACTION->RUN MACRO -> calculateResult(not available) Please send me solution

[@PPTVBA]

The code is available from my website. Please copy the Sub Routine for "Calculate Result"

[@yamuneshsingh123]

Please some video make hindi language

[@user-ym8gd5lh6i]

show result is unclickable. don't go to calculate result even if you click it

[@PPTVBA]

Hi, please confirm if you've followed all steps properly. You can share your file with me via email for me to have a look, or you can download the free template available on the website (make sure to enable editing and macros after downloading the file).

[@pohprinceofhell987]

You didn't tell how to the calculation result and all of a sudden there is a calculation result in the action 😡you make my project time waste what a waste of time

[@PPTVBA]

Hey Karma, it was an error in the editing of the video. The entire code is available on my website for you to copy-paste. I've addressed the same in the pinned comment: "I haven't explained "CalculateResult" Macro in the video, the code snippet is seen for a brief second at 8:52. However, you can Copy-Paste the CODE from my website: pptvba.com/quiz-game-percentage/ Thanks"

[@maithvipatel415]

You are the king of PowerPoint