How to add POINTS and TIMER in PowerPoint Quiz Game | PowerPoint Tutorial
Vložit
- čas přidán 27. 08. 2022
- Let's make a PowerPoint Quiz Game that calculates points (correct & wrong answers) and has a time-limit countdown timer for each question!
Copy Quiz Game VBA Code: pptvba.com/how-to-make-powerp...
Download Free Quiz Game Templates: pptvba.com/free-powerpoint-qu...
00:00 Demonstration
00:24 Quiz Game with Points
03:00 Quiz Game with Timer
Step 1: Adding Timer
Let's add 10 seconds timer for each question! Add a rectangle shape on the slide and add the Exit: Wipe Animation from the right. Change the animation duration to 10 seconds.
Now, go to Transition | Advance Slide, and check After: 00:00:00. The next slide will automatically be shown once the exit animation is complete. However, our next slide is the 'Correct Answer', we would not be needing that as we'll be now calculating the number of correct and wrong answers given by the player in the next step!
Step 2: Scoring Points
Delete all the slides except the first title slide, and one question slide. Create another slide to display your scores. Have 3 shapes: nCorrect, nWrong, nPoints. The text within them would change based on the clicks on the answers.
You can enable your developer tab as it is not shown by default and add the following VBA Code by Developer | Visual Basic | Insert | Module. Then, run these macros on click of the shapes: Select Shape | Insert | Action | Run Macro.
Slide 1: Next Shape → StartGame
Slide 2: Correct Answer → CorrectAnswer
Slide 2: Wrong Answer → WrongAnswer
You will have to remove your custom sound effects if you choose to have a MsgBox to tell your player if their answer was correct or wrong. However, you can use the default Windows Sound Effect through vbInformation and vbCritical in the code.
----------------------------------------------------------------------------------
Music: Outside Visitors · Sarah, The Illstrumentalist
Thumbnail by Vani Agrawal
#PowerPoint #PowerPointTutorial #PPTVBA
I also do freelancing.
🟥 Bhavesh Shaha,
📧 bhavshaha@gmail.com
🌐 www.pptvba.com
🎥 / bhaveshshaha
📷 basicallybhavesh (DMs are open) - Jak na to + styl
This videos are really very cool! Learnt something new today! Thanks so much!!
Very helpful video. Thankyou for this!
I cannot believe you were able to explain such an amazing project within 5 minutes. Jesus Christ thank yooouu!!
I like your ideas 👍🏻👍🏻
Thank you very much! I really appreciate it!
hi! i shared the powerpoint with a class but it seems like none of the buttons work (even from the “game start” button). how to fix this? thank you!
Hello, very interesting, I wish you could help me in my project, with the creation of a game. It is a game that carries macros. I'm struggling to get the game to take lives (a heart-shaped shape simulating life disappearing), after removing a certain number of points on a label that is the score counter, on each wrong answer. Let's say it would be a macro that you can add to every wrong answer shape.
So when you press the answer and it is wrong, then, the macro removes for example 10 points and also removes or disappears the heart that simulates life, at the end, let's say the 3 lives, a Game Over message appears, and restart the game. Well, maybe you could, do a tutorial where you could explain how to achieve that. Something brief but practical. Or maybe, you could orient me with a macro, similar. Anyway, thank you!!!!
Do you have multiple hearts and you need to hide each of them based on the points in the counter? Or do you have only one heart shape?
@@PPTVBAI have multiple hearts and I need to hide each of them based on the points on the counter, let's say three hearts, and they are hidden when you answer badly, which are also subtracted let's say 50 points, while by correct answer you receive, let's say 30.
Hi! Thanks for your tutorial. I have a question. After the end of quizz and when I reopen the presentation report card doesn't update. I mean the numbers of correct answers, wrong and point are saved. Is it real to fix?
When the "Start Game" button is clicked, it resets all the numbers because it runs the following code:
Sub StartGame()
nCorrect = 0
nWrong = 0
nPoints = 0
ActivePresentation.SlideShowWindow.View.Next
End Sub
Sir do you a timer the is continuous? example the whole quiz is set for 5 minutes
can i make timer using text box which user put how many time he need ...... to chalange to solve multiplication question for example....
If you want to change the countdown value directly in Slide Show Mode without touching the VBA Code, we can add an ActiveX Element Textbox named TextBox1 in our slide. We can type the number of seconds we would want the countdown to occur within it. This input is going to be the value of the variable count. We can read the input using the following code:
count = ActivePresentation.Slides(1).Shapes("TextBox1").OLEFormat.Object.Value
More information:
czcams.com/video/u2wDxkDmqbU/video.html
Hi Bhavesh, any idea what would be causing my slides not to advance? The first slide (Start Quiz) slide advances fine, but my questions don't advance after the MsgBox appears
Hi! It might be because of the name of the shape might not be matching the name mentioned in the code. Can you share your file via email? I'd be happy to have a look!
Why the VBA keeps losing whenever I close the ppt? Can I do something to make it automatically there whenever I open the ppt?
Save it as .PPTM and not .PPTX
Make sure your macros are enabled.
Hello, i am not able to save the video. it keeps giving me an error about the marco i put in (the following cannot be saved in marco free presentation) what do i do?
As shown at 3:58, please save the file as a .PPTM file instead of your usual .PPTX file.
Pls help I cant print certificate nor send result to excel nor time limit it shows errors. The same occurs when I copy paste code from your website or follow tutorial
I need immediate help
Pls
This is a common error. The VBA features don't work if your macros are disabled. Make sure that your macros are enabled by going to the developer tab, macro security and enable macros.
However, as you say some errors are being shown, please share the specifics of the error. You can also screenrecord the same and share that via email.
hello i like this vid but i need help bc i cant seem to make the scores appear, it's all zero
ty^^
Hi Bella! Can you send me the PowerPoint file you've made to my email? I'll have a look and share the fix. Do note that shape names are case-sensitive in VBA programming.
@@PPTVBA sure! may i ask for your email?
bhavshaha@gmail.com
@@PPTVBA ty ^^
I checked the code you had sent: "With ActivePresentation.Slides(ActivePresentation.Slides.Count)"
This is referring to the last slide of the Presentation. Your scoreboard is in Slide 18 and not Side 43 (your last slide). So, change it to: "With ActivePresentation.Slides(18)"
do you have a code to add time penalty if they put the wrong answer? Say -10 secs for each wrong answers!
This is certainly possible for an earlier version of the PowerPoint Quiz Game that was created: pptvba.com/ppt-quiz-timer/
Here, we had an overall timer. The variable `time` stored the time-limit, and that could be manipulated by `time = DateAdd("s", 10, time)` to add a penalty of 10 seconds (make sure `time` is declared as a global variable too!)
I followed all the step but it's not showing me the totally score please help me out with that
Cross-check if the name of the shape is exactly the name mentioned in the code (note: they're case-sensitive), if issues persist, you can send me your file on my email and I can have a look, else, you can also download our free template and reverse-engineer it!
@@PPTVBA ok thank you.. let me check again
Hello sir, can you help me with how can the score be detected when not being clicked by the students? The score will just leave as it is when used by the previous student.
When the game is played from starting, the scores of the last student are reset!
@@PPTVBA What I mean sir is when they don't click any of the choices from each questions, it never label 0 points.
@@markusvillame4422 ah got it! Use the following code:
Sub StartGame()
nCorrect = 0
nWrong = 0
nPoints = 0
ActivePresentation.SlideShowWindow.View.Next
UpdatePoints
End Sub
@@PPTVBA thank you so much sir.
@@PPTVBA Sir the code is not working
how does the count add up???
pptvba.com/how-to-make-powerpoint-quiz-game/
Explained in this blog article!
The game always crashes around the 10th or 11th slide. How come? Doesn't the code allow for more than 10 questions?
Can you email me your file? Will have a look! I've played this with 100 questions without an issue.
@@PPTVBA What email can I send it to?
In fact, I think there is something blocking the presentation but I don't understand what. I hope you can help me.
The email is in the video description: bhavshaha@gmail.com
Please make sure that your macros are enabled: pptvba.com/faq
@@PPTVBA Thanks, I'll send you everything later.
My presentation also includes background music but I don't think that's the problem. There is something that creates conflict.
@@PPTVBA I sent you the file.
I hope you can help me.
The scores are not being counted properly how to fix??
Send over your file on email, will have a look!