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.
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.
Part 2: th-cam.com/video/c2e_SwTC5IY/w-d-xo.html We will be adding labels for the number of correct and wrong answers, total and passed questions. We will also show the Points and Percentages scored. Adding TIMER in PPT Quiz: th-cam.com/video/coSOGwR9CgE/w-d-xo.html
I need to know how the codes and scripts function in the VBA. My professor will kill me if i will not make it. :'( Please help me.. Even my classmates can't help me with this. Please..? Please? Please?
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!
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
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.
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
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
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
th-cam.com/video/Yd5wPOVVG7M/w-d-xo.html yes! I made this one for a teacher. Please tell me if you need something of that sort. My email is 2002bhavesh@gmail.com, 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).
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!
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.
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?
@@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
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.
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
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
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 ?
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.
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.
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 2002bhavesh@gmail.com 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.
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
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
@@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.
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 !
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.
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 !
I know that you do not require this feature because this comment is long due but I release the tutorial: th-cam.com/video/oGpbLDyjGrY/w-d-xo.html where we can send data to excel. It could be helpful for people going through the comments section.
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?
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
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
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.
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 2002bhavesh@gmail.com Thank you.
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
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?
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.
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*.
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 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.
@@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.
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
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!
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.
I tried your interactive quiz..but after shutting down my computer, all the macros were disabled..I cannot play the games. Even I enabled the macros in trust center, the quiz won't play. I hope you could help me what to do. Thank you.
Hello! and Thank you for your videos!! I want to create a powerpoint trainning presentation. At the end of the presentation I want to have a button that exports the name and current date to an excel file, to have a record of those who totally viewed the presentation. Can you please tell me how to do this? Can you help me with vba code?
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?
Hello, thank you for the presentation. it was a lifesaver. I am trying to change the design style but when I do, I get the following error " Item CName not found in the Shapes collection" when I go to the name and location page. (I downloaded the one with the certificate). How do I debug? I also wanted to know how to add feedback to each wrong answer so the students know why the answer is wrong. Thank you
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.
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.
Yes, gladly! This is the code: If SlideLayoutXX.CA = 10 Then ActivePresentation.SlideShowWindow.View.GotoSlide (1) Else ActivePresentation.SlideShowWindow.View.GotoSlide (2) End If
Hi...thank you so much for your tutorial. But may i ask you something about the score why the score is always changing. In 10 questions it should be 100 but sometimes become 110 or 80 even if I answer all of them
Ah, this would imply that there is some sort of a problem in your codes. Please feel free to download the sample file provided in my website (link in description) and crosscheck. Else, if you email me the file, I'll have a look at it.
![[FULL EP.73] เปิดบ้าน 70 ล้าน "แป้ง Zbing" ยกมาทั้งญี่ปุ่น l เคหสถานบานปลาย l One Playground](http://i.ytimg.com/vi/YBnJhTt07Pg/mqdefault.jpg)
![เกิดใหม่ทั้งทีก็เป็นสไลม์ไปซะแล้ว ซีซั่น 3 - ตอนที่ 70 [ซับไทย]](http://i.ytimg.com/vi/IbBEqbse4Oo/mqdefault.jpg)
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.
Glad to help you out!
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.
Thank you so much for your kind words!
Part 2: th-cam.com/video/c2e_SwTC5IY/w-d-xo.html
We will be adding labels for the number of correct and wrong answers, total and passed questions. We will also show the Points and Percentages scored.
Adding TIMER in PPT Quiz: th-cam.com/video/coSOGwR9CgE/w-d-xo.html
I need to know how the codes and scripts function in the VBA. My professor will kill me if i will not make it. :'( Please help me.. Even my classmates can't help me with this. Please..? Please? Please?
Everything is in the description. Sorry for the late reply.
Please try downloading the file given in the description. Make sure your macro security is enabled. Check if the sample file works.
+Bhavesh Shaha okay, I'll check right now
bhai link nahi hai
Very nice videos of ppt.
Thanks !!!
Please upload More videos of VBA Course
👌👌👌
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!
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
Glad i could help you out!
I have been searching and searching for help on how to do this. Thank you so much for a clear, easy to follow explanation!!
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.
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
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
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
Thank you very much!
Thank you! 2016 Bhavesh AND 2021 Bhavesh were very helpful.
2016 Bhavesh is ecstatic that someone as awesome as you is my best friend. 2021 Bhavesh is laughing that you spelt MsgBox as MagBox.
THIS IS AMAZING!!! WHY HAVEN'T I DISCOVERED IT EARLIER !! today is 2020 btw
YOURE IN FOR A TREAT THEN! POWERPOINT VBA IS LOVE AHAHAH
Glad to have you all on board to the PPT VBA train !
Well done!!
Excellent work!
I highly recommend these tutorials - you have a fan in Manitoba Canada
:)
You are Awesome Bhavesh ... loved your video...
Thank you so much. I downloaded your presentation & modified it to match my students' needs.
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.
th-cam.com/video/Yd5wPOVVG7M/w-d-xo.html yes! I made this one for a teacher. Please tell me if you need something of that sort.
My email is 2002bhavesh@gmail.com, 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).
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.
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!
If You guys find out a way for team Work do let me know!
Thank you!!! Great Video!! Will be making my own quizzes for my kids now!!!
That's amazing to hear! Glad you liked the tutorial! I have more ppt game tutorials too! Do check em out!
Thankyou Bhavesh it works it is so easy when you know how
extremely thankful for this video, was working on an assignment to make an interactive quiz and was stuck at the scores/ points part
you taught me very nicely so i have subscribed and liked - well done
Brilliant tutorial, thank you! It took me a few tries, but is working great now.
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.
This video is really well done. Thank you for your contribution! You are a great teacher!
Awesome....looking forward for more something new.
In 12 minutes, you explained it all :-). Thank you.
ok did it again, and downloaded your templates. Thank you so much it's just what I needed for my lessons. :-)
This was fantastic - so helpful!
Exellent explanation. Thnaking you.
May 5 2020.... man.. you are the best... more power from Philippines
Thank you very much!
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?
this is awesome 😀
Amazing, U are amazing, have made multiple quizzes using this format
Thank you very much!!! This is very helpful!!!
Literally the best tutorial out there.
Thank you for your kind words!
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 🤍🤍🤍
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.
@@PPTVBA I’ve subscribed you, I’ll check it out soon! God bless you in whatever you do 🥺🙏🏼✨
@@anisxsofia ay thank you xD
@@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
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.
Clearly explained, thanks bhavesh
Thank you very much. I have also made more parts in which you can add percentages at the end of the slide.
thanks for this. it really a great help for me since I have a problem in scoring part of the game ♥
Thanks for your video. Very clear explanations.
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
By adding parentheses, it assumes it to be a number instead of text. For eg: 5 + 10 = 510, (5) + 10 = 15.
Thank you so much Bhavesh! You help a lot in my assignment..
Glad to hear that! This ppt quiz tutorial series have more 6 parts too!
very useful for multiple choice questions Thanks lot
thx buddy it helped me a lot at scholl
Thank you, this was really helpful!
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
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 ?
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.
Thank you very much, Sir. My salute to you. This is very helpful. From Philippines here.
Glad to help!
Glad to help!
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.
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 2002bhavesh@gmail.com 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.
I haven't heard back from you. Are you still interested?
Thanks a lot. Very informative indeed.
Brilliant. Very good job. Keep it up.
Dhanyavad!
This is excellent tutorial! Thank you very much :)
Glad it was helpful!
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
Hi! You can change the slide-layout of all the question slides to the one that has the Scoreboard on it!
I'm very impressed. Keep up the good work! :)
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?
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?
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
@@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.
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 !
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.
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 !
I know that you do not require this feature because this comment is long due but I release the tutorial: th-cam.com/video/oGpbLDyjGrY/w-d-xo.html where we can send data to excel. It could be helpful for people going through the comments section.
Good One. Thank for the details
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?
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
th-cam.com/video/3WbJCGoSzhU/w-d-xo.html
This video is what you would need.
XD THANKS A TON :D
Thanks again! :)
This is very helpful! Is there a way to do this quiz with multiple correct answers?
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.com/ppt-quiz-random-shuffle/
very informative and innovative.... thanks
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.
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 2002bhavesh@gmail.com
Thank you.
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
Glad to hear that the event was a success!
Alright, I'll be making for mobile real soon!
Yes, JavaScript is used for that.
Very good tutorial. Thanks
Love this... How would you set up a score board for two teams, that is, two scores and finally, a winner
You can incorporate a scoreboard in your PowerPoint via this: th-cam.com/video/wmkNUhjf57E/w-d-xo.html
You are doing great. I am using it for my blogger
What is your blogger site?
@@PPTVBA bktmexfeed.blogspot.com/
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?
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.
tnx for the help.. God bless
nice! thanks for having this video. Very helpful. God bless!
Thank you very much!
Hello and a big thank you for your explanation. I have a question. Can these games be used online?
Unfortunately VBA is compatible only with the offline PowerPoint Application in Windows and MacOS.
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.
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*.
Hi Bhavesh... Good Work... Keep it up... Really very useful.... Can you also provide coding for scoring along with time line... ???
"Scoring along with time line..."
Wait. What?
I'm unable to understand your query.
Excellent! Thanks a lot. I like it. I'm going to use it .
Thank you soo much
Great video! Thanks. Have you made a tutorial on adding music and sound effects?
I'll be certainly making one on this real soon. Thank you for suggesting.
Hi Bhavesh my exit button is not working
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 :)
Yes we totally can! Please send me your file and I can have a look at the errors.
@@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.
@@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.
@@PPTVBA Thank you for the prompt reply. I have shared the ppt with you via Gmail.
Ammmmmazing.. keep it up.. and your voice is soooo sweet.. god bless.
Ahaha thanks a lot! This video was upload a long time back! Please do watch the entire playlist!
Very nice explained. Is there also a possibility that there is a sound when the message good or wrong is coming?
Yes! You can add a trigger animation for the audio clip which is run when the appropriate shape is pressed.
@@PPTVBA Can you show me how this could be done?
I'll make a tutorial in a few days!
@@PPTVBA I will use this game next monday, should it be possible before next monday?
Thank you so much for your great sharing. Could you please share how to input the tester's name in the quizzes results ?
Yes, please watch the consecutive parts of this series. I've put the links in the description.
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
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!
hi! Could you tell me why we have to create a slide master? Can't we put the code in a normal slide?
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.
Good it is very useful and clear.
I tried your interactive quiz..but after shutting down my computer, all the macros were disabled..I cannot play the games. Even I enabled the macros in trust center, the quiz won't play. I hope you could help me what to do. Thank you.
Have you saved the file in the correct format?
Save as .pptm not .ppt
Hello! and Thank you for your videos!!
I want to create a powerpoint trainning presentation. At the end of the presentation I want to have a button that exports the name and current date to an excel file,
to have a record of those who totally viewed the presentation.
Can you please tell me how to do this? Can you help me with vba code?
th-cam.com/video/oGpbLDyjGrY/w-d-xo.html
Here is a tutorial!
Very useful tutorial
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?
stackoverflow.com/questions/65147457/navigate-to-ppt-slide-by-its-id-or-name-instead-of-number
Check this out.
@@PPTVBA Thank you man!
Hello, thank you for the presentation. it was a lifesaver. I am trying to change the design style but when I do, I get the following error " Item CName not found in the Shapes collection" when I go to the name and location page. (I downloaded the one with the certificate). How do I debug? I also wanted to know how to add feedback to each wrong answer so the students know why the answer is wrong. Thank you
Thank you so much! It really helps a lot. GBU
Glad the PowerPoint Quiz Game helped you out!
Really good.. and it works... but cant use it on mobile phone.. is there any way!
Yes! I can make android app for this. Are you interested in hiring me?
Hi, Is there anyway to initiate a shape animation with VBA?
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.
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.
There's another method to do that too. We can make a UserForm and use that as a messagebox.
Hey, will an macro enabled powerpoint also work if you upload in Google slides
(upload Powerpointpresentation) in google slides
Sorry, VBA Macros do not work in google slides.
awesome work buddy, very impressed
Hello, Great Tutorial!!! Is there a Macro to save the quiz results and/or possibly email to a specified email address??? thanks in advance!
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.
@@PPTVBA Can You please link to the macro or point me in the right direction?
th-cam.com/video/iCPc8yaLDGM/w-d-xo.html Do check this video. You can print the result slide as .PDF
!AWSOME! You are amazing
Thank you for your tutorial, it's extremely helpful. How can I modify the codes to create multiple response questions?
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.
it's very usefull thanks alot
thank you so much, big help to me
if each correct question gets 10 points and wrong ones get minus 5 why do I get wrong result at the end. Where is the mistake? please tell me
Thank Your very much, this was really amazing and halpful
Glad to help! I have another video where you make a report card with the quiz resutls
Is it possible for have more than one correct answer and score the points?
Thank you for a great video! 😍 And can you teach me how to do 'if the result = 10 then go to slide 1, else go to slide 2'? Thank you very much!
Yes, gladly! This is the code:
If SlideLayoutXX.CA = 10 Then
ActivePresentation.SlideShowWindow.View.GotoSlide (1)
Else
ActivePresentation.SlideShowWindow.View.GotoSlide (2)
End If
Hi...thank you so much for your tutorial. But may i ask you something about the score why the score is always changing. In 10 questions it should be 100 but sometimes become 110 or 80 even if I answer all of them
Ah, this would imply that there is some sort of a problem in your codes. Please feel free to download the sample file provided in my website (link in description) and crosscheck.
Else, if you email me the file, I'll have a look at it.