How to make PowerPoint Interactive Quiz Game | Points/Percentages/Score | PPT VBA Macro Tutorial

[@gullwingsyrp88]

Love this tutorial, watching this in 2020 after parents are having to teach their children due to school shutdowns because of COVID19. Was trying to figure out how to make learning more fun for my child.

[@PPTVBA]

Glad to help you out!

[@sesughdangi4674]

My name is Ambrose from Nigeria. I just discovered this channel when I wanted to build a game show for my children. Coming this has changed my classroom and quizz experience completely. Thanks so much and I look forward for giving in my little support to this channel as soon as possible.

[@PPTVBA]

Thank you so much for your kind words!

[@mariociencia12]

Very well explained! Thanks for the availability of the resources, such as the ppt file and the code. Please do more videos about the use of VBA in Powerpoint!

[@jitendrabomble2218]

Very nice videos of ppt. Thanks !!! Please upload More videos of VBA Course 👌👌👌

[@bejai1962]

I have been searching and searching for help on how to do this. Thank you so much for a clear, easy to follow explanation!!

[@PPTVBA]

Thank you very much for your appreciation. I also have more parts regarding this, in which I add percentage, non of correct and incorrect answer etc. It is in the description.

[@bejai1962]

Just wanted to let you know I figured out how to get my results page to print!!! It took a while because I'm teaching myself and there's so much I just don't know. But I love what I'm learning and it's so exciting!! Thank you so much for the instructions. With collective information from you and others, this is my coding below: Sub Correct() Points.Caption = (Points.Caption) + 1 Output = MsgBox("Your answer is correct, well done!", vbOKOnly, "Correct Answer") ActivePresentation.SlideShowWindow.View.Next End Sub Sub Wrong() Points.Caption = (Points.Caption) - 1 Output = MsgBox("Your answer is wrong,", vbOKOnly, "Wrong Answer") ActivePresentation.SlideShowWindow.View.Next End Sub Sub PrintSlide() SldNo = ActivePresentation.Slides.Count ActivePresentation.PrintOptions.OutputType = ppPrintOutputSlides ActivePresentation.PrintOut From:=9, To:=9 End Sub Sub Reset() SlideLayout26.Points.Caption = 0 ActivePresentation.SlideShowWindow.View.Exit End Sub

[@shonellamorgan1867]

This is soooo awesome!!! Thanks for sharing. This helped me with my assignment. I was getting so frustrated because I have an assignment and did not know what to do. Thanks again

[@PPTVBA]

Glad i could help you out!

[@gonzalobernalferreira3870]

Thank you very much, I think that in my teaching life it is the best tutorial I have seen, given the complexity of the subject for those of us who do not know anything about programming, but if we use powerpoin in our daily work. I congratulate him and send him my most sincere congratulations

[@PPTVBA]

Thank you very much!

[@vaniagrawal4142]

Thank you! 2016 Bhavesh AND 2021 Bhavesh were very helpful.

[@PPTVBA]

2016 Bhavesh is ecstatic that someone as awesome as you is my best friend. 2021 Bhavesh is laughing that you spelt MsgBox as MagBox.

[@djafmess4008]

Thank you so much. I downloaded your presentation & modified it to match my students' needs.

[@AlaaMostafa-i3i]

Your work is really amazing, amazing, amazing, the best VBA PowerPoint explainer content on the entire internet . Please continue. She started strong, and will continue as a star and champion . you are the first without disputed . Thank you very much

[@karlnikolasalcala8208]

THIS IS AMAZING!!! WHY HAVEN'T I DISCOVERED IT EARLIER !! today is 2020 btw

[@PPTVBA]

YOURE IN FOR A TREAT THEN! POWERPOINT VBA IS LOVE AHAHAH

[@PPTVBA]

Glad to have you all on board to the PPT VBA train !

[@fishbloke100]

Thankyou Bhavesh it works it is so easy when you know how

[@parcival]

This video is really well done. Thank you for your contribution! You are a great teacher!

[@abhianvnepal8922]

you taught me very nicely so i have subscribed and liked - well done

[@arvindjanardhan2173]

Amazing, U are amazing, have made multiple quizzes using this format

[@ebishirl]

Brilliant tutorial, thank you! It took me a few tries, but is working great now.

[@lakshmanank7256]

In 12 minutes, you explained it all :-). Thank you.

[@johnbeaubien8826]

Well done!! Excellent work! I highly recommend these tutorials - you have a fan in Manitoba Canada :)

[@sagarrao781013]

extremely thankful for this video, was working on an assignment to make an interactive quiz and was stuck at the scores/ points part

[@AdaKoppejan]

This was fantastic - so helpful!

[@ookii654]

Thank you!!! Great Video!! Will be making my own quizzes for my kids now!!!

[@PPTVBA]

That's amazing to hear! Glad you liked the tutorial! I have more ppt game tutorials too! Do check em out!

[@shivamraut1252]

You are Awesome Bhavesh ... loved your video...

[@bridgetgainous5487]

I love this. Is there a way to have points for more than one player? I am a teacher, and I like to have the students play with teams.

[@PPTVBA]

kzbin.info/www/bejne/j5WYqIOFi7t6ba8 yes! I made this one for a teacher. Please tell me if you need something of that sort. My email is [e-mail], we can communicate further if you're interested. Thank you! Edit: have you seen the other parts of this tutorial? I have also added percentages in part 6(if I'm right).

[@bridgetgainous5487]

Bhavesh Shaha Yes, this video was perfect. I will email you after I try to make my quiz. My kids like to keep team points.

[@PPTVBA]

Yeah that'd be great. I also do freelancing and you can also purchase the full version with custom designs and animations as per your choice for a very small fee. Thank you!

[@surbhigoel4869]

If You guys find out a way for team Work do let me know!

[@israelcudia]

May 5 2020.... man.. you are the best... more power from Philippines

[@PPTVBA]

Thank you very much!

[@alexneves7809]

ok did it again, and downloaded your templates. Thank you so much it's just what I needed for my lessons. :-)

[@timeaturai7126]

this is awesome 😀

[@anisxsofia]

For the sake of getting an A for my CALL Assignment, I’ll be using your idea. You are indeed a genius! Thank you for sharing 🤍🤍🤍

[@PPTVBA]

Ayyy! Thank you so much! Get that grade xD ace that test. Good luck. I have 6 more parts to this if you want to impress your professor.

[@anisxsofia]

@@PPTVBA I’ve subscribed you, I’ll check it out soon! God bless you in whatever you do 🥺🙏🏼✨

[@PPTVBA]

@@anisxsofia ay thank you xD

[@anisxsofia]

@@PPTVBA sir, why if we save our point point to power point macro enabled show, we cannot write the answers in fill in the blank activity. It must be saved for pp macro enabled presentation hmmmmmm

[@PPTVBA]

Yes. Anything involving macros or activex element must be saved as .ppsm or .pptm This is to differentiate normal presentation and a presentation that contains visual basic code.

[@sasikalam1531]

Clearly explained, thanks bhavesh

[@PPTVBA]

Thank you very much. I have also made more parts in which you can add percentages at the end of the slide.

[@kazimrahman7499]

Awesome....looking forward for more something new.

[@paramananthensivakolunthu2876]

Exellent explanation. Thnaking you.

[@Waitxn]

Literally the best tutorial out there.

[@PPTVBA]

Thank you for your kind words!

[@rajavarmanslb3745]

very useful for multiple choice questions Thanks lot

[@cosmin230]

thx buddy it helped me a lot at scholl

[@ice4chill]

Thank you very much!!! This is very helpful!!!

[@melanioflorino5674]

Thank you very much, Sir. My salute to you. This is very helpful. From Philippines here.

[@PPTVBA]

Glad to help!

[@PPTVBA]

Glad to help!

[@tanisha8520]

Thank you, this was really helpful!

[@louis-fredericktelot9901]

Thanks for your video. Very clear explanations.

[@seemamunshi9533]

Very good explanation. Can we get shape name as correctans and wrong ans and increase decrease points depending on that instead of setting actions in each slide.

[@applekyeopta2761]

thanks for this. it really a great help for me since I have a problem in scoring part of the game ♥

[@Checkagile]

Good One. Thank for the details

[@geetikakapoor1426]

Thanks Bhavesh. very well explained. The option to copy paste the code was very useful. Can you help with a quiz format where the quiz slides repeat themselves in the fixed order, until the student gets a 100% mastery for the entire block?

[@brahimachtbi3351]

Thanks a lot. Very informative indeed.

[@rossettydolly3085]

Thank you so much Bhavesh! You help a lot in my assignment..

[@PPTVBA]

Glad to hear that! This ppt quiz tutorial series have more 6 parts too!

[@qamarjaunpuri4168]

Brilliant. Very good job. Keep it up.

[@PPTVBA]

Dhanyavad!

[@anilkodakkadan]

very informative and innovative.... thanks

[@infoworld3091]

Very good tutorial. Thanks

[@ruthbrillo4751]

nice! thanks for having this video. Very helpful. God bless!

[@PPTVBA]

Thank you very much!

[@jlmagz4560]

tnx for the help.. God bless

[@user-bs1yt6oj1c]

Thanks for your nice tutorial. It helps me learn. Can you tell me what the purpose of the parentheses is in this line of your code: Points.Caption = (Points.Caption) + 10

[@PPTVBA]

By adding parentheses, it assumes it to be a number instead of text. For eg: 5 + 10 = 510, (5) + 10 = 15.

[@bibintharian4093]

You are doing great. I am using it for my blogger

[@PPTVBA]

What is your blogger site?

[@bibintharian4093]

@@PPTVBA bktmexfeed.blogspot.com/

[@bibintharian4093]

First I want to add the provision for skipping the question. Just like a exam... Anyway you are doing a great job.... Can I use your material with your permission?

[@PPTVBA]

Yes! feel free to use this for education. I only forbid people who re-purpose my video/file/code and make another tutorial on this.

[@tehmalayspartan]

I'm very impressed. Keep up the good work! :)

[@dhavaldwivedi]

Very useful tutorial

[@jenkostation]

This is excellent tutorial! Thank you very much :)

[@PPTVBA]

Glad it was helpful!

[@nishannaidoo1318]

Love this... How would you set up a score board for two teams, that is, two scores and finally, a winner

[@PPTVBA]

You can incorporate a scoreboard in your PowerPoint via this: kzbin.info/www/bejne/rZ7Of4ien8tobac

[@pbrmgrbibhoal]

Good it is very useful and clear.

[@banaarsyntax577]

Ammmmmazing.. keep it up.. and your voice is soooo sweet.. god bless.

[@PPTVBA]

Ahaha thanks a lot! This video was upload a long time back! Please do watch the entire playlist!

[@princeyahwetv]

Amazing

[@orlandomurcia4924]

Excellent! Thanks a lot. I like it. I'm going to use it .

[@mariemloghmari8662]

Very well explained thank you so much ! Is there a way to add a countdown that will automatically stops the quiz after 20 min? And is there a way to send the score with student's name in another excel spreadsheet? That would be super helpful !

[@PPTVBA]

Yeah! There is a way to sent the results in a spread sheet. I'm not sure about the 20 minute timer though. I know of a way to add individual timers for each question. I'll make the excel video by this week.

[@mariemloghmari8662]

Bhavesh Shaha amazing ! Thank you so much ! If there is not a way to add a countdown, is there a way to add in the excel spreadsheet as well as in the PowerPoint how many minutes the student took to do the test ? And one last thing if possible, could you please show how to do an automatic ranking in the excel spreadsheet with the best score ? And maybe at the end of the score a kind of : TADADADA ring, to show results 😂 just to make it funnier hahaha (Even if you showed us half of it I would be forever grateful !) That would be literally a BLESSING ! Have a nice day ! And can’t wait to see the video coming !

[@PPTVBA]

I know that you do not require this feature because this comment is long due but I release the tutorial: kzbin.info/www/bejne/pXjTk396rs96qLs where we can send data to excel. It could be helpful for people going through the comments section.

[@sanjanasanju6507]

Thank you soo much

[@enjolijimenez3858]

Hi! This is a very good tutorial! I am a little nervous to try it out for what I need it for and wanted to ask your thoughts. I am a preschool director and I must give baseline testing to all the children; however, our learning goals are not like other schools so a regular test does not work well for our needs. Do you think I can add shapes and colors, etc. for the students to visually see the question since they are not reading at this age? Also, for a beginner , how long do you think it will take me to create something specifically for my school? Lastly, are you available for higher? Honestly we do not have very big budgets at my school; however, I would like to know if this is something you could create for us. Kind regards, and thank you again for the post.

[@PPTVBA]

Thank you for your kind words. Yes, shapes and colours can be added as per your creative needs to the maximum extent possible in Microsoft PowerPoint. For example, you can have picture-answers instead of the boxes which contain the answer; clicking on the picture will give a point, and you can have lots of animations etc. I think I'll need to know more factors to properly determine how much time it would take to make something like this- How many questions? How many slides? Extra features? Amount of Animations? Designs? etc. I'd like to know more information at [e-mail] to know if I can do this because currently I'm in Grade 10 in India and have very important exams so I will be unable to say for sure. Thank you.

[@PPTVBA]

I haven't heard back from you. Are you still interested?

[@peavee69]

awesome work buddy, very impressed

[@alisadti5491]

it's very usefull thanks alot

[@helloeaes5701]

amazing tutorial! just asking if there would be a way to make the player win if they get 3 or more points and lose if they get anything below 3?

[@PPTVBA]

Yep! Definitely! We can have multiple if then conditions and get that to occur. Can you please detail how you'd want the win/lose to be indicated?

[@helloeaes5701]

cool! i have an end screen, and i would like a text box on the screen to say that you won when you get 3 or more, or say that you lost when you get less than 3

[@PPTVBA]

@@helloeaes5701 ah got it! Do check the later tutorial parts where I explain how to have a report card. You can use a similar method to have a conditional congratulations text.

[@Hasan-bc6rr]

This was great, I love your step-by-step explanation. How can I put the scorekeeping widget on every slide so it is always visible as I answer all the questions? I could not just copy it over to other slides. thanks

[@PPTVBA]

Hi! You can change the slide-layout of all the question slides to the one that has the Scoreboard on it!

[@rinalugatiman2520]

Thank you so much! It really helps a lot. GBU

[@PPTVBA]

Glad the PowerPoint Quiz Game helped you out!

[@enikomihaly1842]

Hello and a big thank you for your explanation. I have a question. Can these games be used online?

[@PPTVBA]

Unfortunately VBA is compatible only with the offline PowerPoint Application in Windows and MacOS.

[@user-cv2bh4gj6h]

Love your ppt games. However i noticed a flaw children are very smart they notice the correct answer is always the first option. Can you make a tutorial of how to get around this problem without writing multiple macros. So changing the correct answer position on each slide. Many thanks T.William

[@PPTVBA]

pptvba.com/ppt-quiz-random-shuffle/

[@jullalexcalmorin9659]

thank you so much, big help to me

[@nooraniyaenglishschoolrajk1811]

Hi Bhavesh... Good Work... Keep it up... Really very useful.... Can you also provide coding for scoring along with time line... ???

[@PPTVBA]

"Scoring along with time line..." Wait. What? I'm unable to understand your query.

[@yosefnedjar8870]

!AWSOME! You are amazing

[@mikeyjrful23]

Hi Bhavesh! I just recently saw your video and this tutorial was amazing. Thank you so much! I have teams for the powerpoint game I am using and I want to add or subtract points to each team. If there is a way to do this, I would really appreciate it :D

[@PPTVBA]

kzbin.info/www/bejne/aYjFe3Z9pLitnrc This video is what you would need. XD THANKS A TON :D

[@mikeyjrful23]

Thanks again! :)

[@tessnorman]

Thank you so much for this tutorial! Amazing job! Subscribed and liked. Do you know if it's possible to run this on a tablet? It works perfectly on my computer but the macro doesn't work on my tablet. I have a Samsung Galaxy Tab A.

[@PPTVBA]

Thank you very much. I used VBA-macros which work only with PCs. However, they are many many alternatives for making a quiz game which works in Mobile. The most simplest way is to make a web-based quiz, you basically use hyperlinks and host them on a free server. Or, you could make an android quiz game, which requires you to know coding. I will be making a tutorial on that, it's on my list. I also work as a freelancer, contact me at [e-mail] Thank you.

[@tessnorman]

Thank you so much for your reply! I ended up making this quiz game for an event at work and everybody loved it, including my boss =) Just did it on my computer which was good. Please make the tutorial on the android game! That would be awesome. =) Which coding language do you use for that, is it Javascript? And thanks for your contact, I will for sure hit you up when the need arises at work. Best, Therese

[@PPTVBA]

Glad to hear that the event was a success! Alright, I'll be making for mobile real soon! Yes, JavaScript is used for that.

[@sheetsofcotton]

This is very helpful! Is there a way to do this quiz with multiple correct answers?

[@karmenmott9229]

Thank Your very much, this was really amazing and halpful

[@PPTVBA]

Glad to help! I have another video where you make a report card with the quiz resutls

[@joseemiliobacaniklas7654]

hi, muy buenos los videos.. interesantes. gracias por compartirlos

[@PPTVBA]

muchas gracias :)

[@alawiali53]

Nice video, but I have a question if there are 6 persons that will do the quiz and I need that they write their name cause to know the results for each one of them so how I can do it ?

[@PPTVBA]

Heya! I have an entire playlist dedicated to quiz game in ppt, there's a video for generating certificate where names can be collected and .pdf of the certificate can be saved.

[@marcovanduin8062]

Very nice explained. Is there also a possibility that there is a sound when the message good or wrong is coming?

[@PPTVBA]

Yes! You can add a trigger animation for the audio clip which is run when the appropriate shape is pressed.

[@marcovanduin8062]

@@PPTVBA Can you show me how this could be done?

[@PPTVBA]

I'll make a tutorial in a few days!

[@marcovanduin8062]

@@PPTVBA I will use this game next monday, should it be possible before next monday?

[@itsmejustletmein]

Great video! Thanks. Have you made a tutorial on adding music and sound effects?

[@PPTVBA]

I'll be certainly making one on this real soon. Thank you for suggesting.

[@sweswelattdr2964]

thanks a lot for your sharing it

[@AymanAfifyAhmed]

I subscribed:) because of ur awesome video

[@PPTVBA]

Thank you :)

[@mokhatri4146]

Thanks this was great!, is there anyway I can integrate this into a presentation? I followed the instructions and the quiz worked, but when I added in other slides (for the presentation) it stopped working (when I click slideshow - from the beginning, it doesn't allow me to go to the next slide in that view). Let me know, cheers :)

[@PPTVBA]

Yes we totally can! Please send me your file and I can have a look at the errors.

[@rajnimonga1628]

@@PPTVBA Hi. I am facing the same issue. Could you please share how you corrected the issue. Also, when I click on the correct or incorrect options, the dialog box doesn't appear.

[@PPTVBA]

@@rajnimonga1628 we just have to fix the variables to match the new presentation. We cannot copy paste it per se. You can send the file to me and I can have a look at it and suggest the changes.

[@rajnimonga1628]

@@PPTVBA Thank you for the prompt reply. I have shared the ppt with you via Gmail.

[@sanjaybodra6906]

Thanks a lot for making this Tutorial. it really helped me to clear my doubt. i have one question that is how to add score for different participants, for example, let's say there are 4 to five participants. please help me out. Thaks

[@PPTVBA]

I have a premium template for this at my website- www.pptvba.com I make multiple scorrboards in a slide master (tutorial on my video) and enbed them along with my question slides!

[@ssmailhr]

hi grt stuff can we highlight the right answer when someone clicks on the wrong one or in the msg box can we mention the right answer. please suggest that will be grt help. thanks in advance

[@nguyenngocthanhphong1726]

Thank you so much for your great sharing. Could you please share how to input the tester's name in the quizzes results ?

[@PPTVBA]

Yes, please watch the consecutive parts of this series. I've put the links in the description.

[@cotisoft2444]

Hey, you have helped me a lot in my game, but I have one question. Can you tell me if there is a code to ActivePresentation.SlideShowWindow.View.GotoSlide (...), that fixes the slide and there is no point changing the code again and again if you add slides?

[@PPTVBA]

stackoverflow.com/questions/65147457/navigate-to-ppt-slide-by-its-id-or-name-instead-of-number Check this out.

[@cotisoft2444]

@@PPTVBA Thank you man!

[@abounarimanedriouch161]

Merci beaucoup

[@messaoudacherif2635]

thanks a lot

[@princeyahwetv]

interesting I'll make this in my research

[@PPTVBA]

I wish you all the best!

[@princeyahwetv]

@@PPTVBA please sub me back ,,,thank you

[@PPTVBA]

@@princeyahwetv alright

[@channel-9india281]

10/10

[@marcosisto1260]

hi! Could you tell me why we have to create a slide master? Can't we put the code in a normal slide?

[@PPTVBA]

Hello! We can insert the label in a normal slide and add the codes to that slide too! I used a slide master because I didn't know any better whilst recording the tutorial.

[@saritassinan]

Teşekkürler.

[@samskaraoffset4564]

Really good.. and it works... but cant use it on mobile phone.. is there any way!

[@PPTVBA]

Yes! I can make android app for this. Are you interested in hiring me?

[@shankarmidatala2049]

Hi Bhavesh, Thanks for this wonderful tutorial. I'm able to follow your instructions and make a PPT based Quiz with scores and its working awesome. I've a question: how to increase the font size of the message like "Correct Answer" or "Wrong Answer" and is it also possible to add music on clicking the Correct answer and a different music on clicking the Wrong answer. Please help.

[@PPTVBA]

1. Yes. Music can certainly be added. Click the shape, go to insert > actions > mouse click > play sound. 2. If you reduce the resolution of your monitor, the message box should become bigger. Another way to implement your idea is by typing that in the slide and making that appear with the help of animation triggers.

[@PPTVBA]

There's another method to do that too. We can make a UserForm and use that as a messagebox.

[@digitalkhetibymitesh4197]

good

[@nikoamplayo5438]

It is applicable when 2 questions are in a single slide? Cause 1 click is automatically skip to the next slide. How when 1 slide is 2 multiple questions and answers.

[@PPTVBA]

This video isn't applicable when you would want 2 questions in the same slide. You can however remove the line of code that takes us to the next slide and only have a *next button*.

[@dano7310]

Thank you for your tutorial, it's extremely helpful. How can I modify the codes to create multiple response questions?

[@PPTVBA]

This is a good topic! I shall put this on my to-do list. I'll try to make a tutorial on this by the month-end.

[@alexneves7809]

so, followed everything step by step but when I got to the part to click on layout and select masterslide view, I didn't have that option... where did I go wrong?

[@sciencepowerpoints]

Hey, will an macro enabled powerpoint also work if you upload in Google slides (upload Powerpointpresentation) in google slides

[@PPTVBA]

Sorry, VBA Macros do not work in google slides.

[@TheCabritoLoco]

Hello, Great Tutorial!!! Is there a Macro to save the quiz results and/or possibly email to a specified email address??? thanks in advance!

[@PPTVBA]

There is a macro which will allow you to save a .PDF file of your result slide. I am not sure about the email thing though.

[@TheCabritoLoco]

@@PPTVBA Can You please link to the macro or point me in the right direction?

[@PPTVBA]

kzbin.info/www/bejne/n3SzlGuvlrF3fa8 Do check this video. You can print the result slide as .PDF