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.
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?
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.
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
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!
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
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, 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!
@@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.
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
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.
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.
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.
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?
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.
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?
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*.
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.
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.
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?
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.
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?
hi dear, I have a big problem with the audio! When I insert an audio file from my PC into a slide !, I set the playback as "Automatically, show off during playback, rewind after playback". Now when the slide I inserted my audio file opens the first time, it works fine. but when I come back another time, the audio file does not work anymore !? does not it start automatically anymore ?! do you know by chance how can I solve my problem ?! Can you help me solve this problem ?! Many thanks in advance..
Have you considered adding the sound effect to the button which takes them to that slide? I don't have my laptop on me right now so I am not sure which option to be used. I'll tell you by 2pm IST
No..! I did not think about it! nice oservation! thank you very much, I am waiting for your answer, I hope you will help me to solve my problem, thanks again ..
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?
Any way to make different animations show up based on score? By that I mean if you get a zero there is a thumb down animation and if you get ten there is a happy face
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
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
Yeah. Please make a start game subroutine that would play when the start game text or button placed in slide 1 would be clicked. Sub startgame() Points.caption = 3 SlideShowWindows(1).view.next End sub
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.
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, i have put music in the background of my quiz, but whenever i press answer and it comes up with 'correct answer well done', the music stops, how to keep it going?
Well. In the vba, add the following code: Sub Retry() Points.Caption = 0 ActivePresentation.SlideShowWindow.View.GotoSlide (1) Then in your button use the actions -> Macro -> Retry
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
hi, thank you so much for your great tutorial! Would like to know is there anyway to make it when you choose the wrong answer, it won't go to the next question, but only show the box that telling you the answer is wrong. Only will go to the next question when you choose the correct answer. but the points counting as usual. Appreciate if you can help. thank you very much.
Is there a possibility to to hyperlink the correct option to another slide instead of giving out a dialog box... Because the dialog box seems tooo plain
Yes, you can do that. Instead of using the MsgBox code, send them to the corresponding correct/wrong answer slide by using *SlideShowWindows(1).View.GotoSlide(x)*, x is your correct/wrong answer slide number.
@@PPTVBA Mine are enabled I believe. It is a copy of the ppt in its entirety. Is there a way to make a copy of it entirely and still have the score board?
is there a way to not show a dialog box for every correct or wrong answer one gets? Instead it is just showed in the last slide where it shows the scores
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
Hello Sir, i am a trainer and would like to ask you is there any way that online ppt users can access to this macro based quiz. As far as i know, web based ppt dont have access to macro. please suggest your views
So i did everything right, but when i insert the macro into a question box, you have to click the right and wrong answer to progress to the next slide. Any solve for this? Thanks!
i meant the answer boxes. when i click one, the correct answer msgbox will appear, but the slide won't progress. it only does when i click the wrong answer box as well. sorry for the confusion!
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.
I'm making a hidden object game using your tutorial to add point. I don't want the 'your answer is correct' box come when I click to the object but I still want the point to be there. Can you help me with that?
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!
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
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!
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
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!
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
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!
Very nice videos of ppt.
Thanks !!!
Please upload More videos of VBA Course
👌👌👌
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
Same here. I had no idea about these properties of ppt :)
Glad to have you all on board to the PPT VBA train !
Thank you so much. I downloaded your presentation & modified it to match my students' needs.
May 5 2020.... man.. you are the best... more power from Philippines
Thank you very much!
Thankyou Bhavesh it works it is so easy when you know how
In 12 minutes, you explained it all :-). Thank you.
Well done!!
Excellent work!
I highly recommend these tutorials - you have a fan in Manitoba Canada
:)
Literally the best tutorial out there.
Thank you for your kind words!
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!
You are Awesome Bhavesh ... loved your video...
you taught me very nicely so i have subscribed and liked - well done
This video is really well done. Thank you for your contribution! You are a great teacher!
Brilliant tutorial, thank you! It took me a few tries, but is working great now.
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.
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!
Amazing, U are amazing, have made multiple quizzes using this format
Hi Bhavesh my exit button is not working
This was fantastic - so helpful!
Thank you very much, Sir. My salute to you. This is very helpful. From Philippines here.
Glad to help!
Glad to help!
Awesome....looking forward for more something new.
extremely thankful for this video, was working on an assignment to make an interactive quiz and was stuck at the scores/ points part
this is awesome 😀
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.
ok did it again, and downloaded your templates. Thank you so much it's just what I needed for my lessons. :-)
Exellent explanation. Thnaking you.
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
very useful for multiple choice questions Thanks lot
Brilliant. Very good job. Keep it up.
Dhanyavad!
thanks for this. it really a great help for me since I have a problem in scoring part of the game ♥
very informative and innovative.... thanks
This is excellent tutorial! Thank you very much :)
Glad it was helpful!
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.
Thanks for your video. Very clear explanations.
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.
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!
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.
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?
Thank you very much!!! This is very helpful!!!
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.
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?
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*.
Very good tutorial. Thanks
thx buddy it helped me a lot at scholl
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!
Good One. Thank for the details
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
I'm very impressed. Keep up the good work! :)
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, this was really helpful!
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.
Thanks a lot. Very informative indeed.
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?
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!
hi dear, I have a big problem with the audio! When I insert an audio file from my PC into a slide !, I set the playback as "Automatically, show off during playback, rewind after playback". Now when the slide I inserted my audio file opens the first time, it works fine. but when I come back another time, the audio file does not work anymore !? does not it start automatically anymore ?! do you know by chance how can I solve my problem ?!
Can you help me solve this problem ?!
Many thanks in advance..
Are you going back to the slide during the same slide show session?
YES, back in the same presentation!
Have you considered adding the sound effect to the button which takes them to that slide? I don't have my laptop on me right now so I am not sure which option to be used. I'll tell you by 2pm IST
No..! I did not think about it! nice oservation! thank you very much, I am waiting for your answer, I hope you will help me to solve my problem, thanks again ..
Try using the buttons. If that works, adding a sound effect for the slides would be unnecessary.
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
Hi, Is there anyway to initiate a shape animation with VBA?
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!
Any way to make different animations show up based on score? By that I mean if you get a zero there is a thumb down animation and if you get ten there is a happy face
stackoverflow.com/questions/43708372/how-to-add-delay-before-going-to-next-slide-in-ppt-using-vba
Good it is very useful and clear.
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 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.
hey, just wondering, any way to make the player start off with 3 points?
Yeah. Please make a start game subroutine that would play when the start game text or button placed in slide 1 would be clicked.
Sub startgame()
Points.caption = 3
SlideShowWindows(1).view.next
End sub
thanks so much! you sure did answer fast
Ahah glad! Lots of PPT tutorials on my channel! Do watch em!
sure will!
Very useful tutorial
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.
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!
it's very usefull thanks alot
Hi, i have put music in the background of my quiz, but whenever i press answer and it comes up with 'correct answer well done', the music stops, how to keep it going?
You can try removing the pop up message.
How about adding a sound to indicate whether the answer was correct or incorrect?
@Arvind Janardhan you should enable the 'play across the slides' option in the music properties
I had tested that too but for me, the music stops when ever a MsgBox pops up.
How would you add retry quiz button hyperlink is no good does not reset points
Well.
In the vba, add the following code:
Sub Retry()
Points.Caption = 0
ActivePresentation.SlideShowWindow.View.GotoSlide (1)
Then in your button use the actions -> Macro -> Retry
tnx for the help.. God bless
Thank you so much! It really helps a lot. GBU
Glad the PowerPoint Quiz Game helped you out!
Sir which theme or template you have used
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! :)
nice! thanks for having this video. Very helpful. God bless!
Thank you very much!
I subscribed:) because of ur awesome video
Thank you :)
hi, thank you so much for your great tutorial! Would like to know is there anyway to make it when you choose the wrong answer, it won't go to the next question, but only show the box that telling you the answer is wrong. Only will go to the next question when you choose the correct answer. but the points counting as usual. Appreciate if you can help. thank you very much.
hm...I figured it out by change the code from "next" to "getclickcount", am I correct? or is there a better way to do it? Thanks
Remove the whole line which contains "Goto.Next". But also know that this would mess up the percentage calculation, if you choose to add that.
got it , thank you very much.
thank you please I would like to keep the cursor in the text box when I received an error message
That's a setting that can be changed within windows. Under Control Panel > Mouse. You will find the option to redirect mouse cursor to dialog box.
Is there a possibility to to hyperlink the correct option to another slide instead of giving out a dialog box... Because the dialog box seems tooo plain
@Bhavesh Shaha
And also thanks for the Idea
Just get back to me Quick cuz I have a kinda strict deadline
Yes, you can do that. Instead of using the MsgBox code, send them to the corresponding correct/wrong answer slide by using *SlideShowWindows(1).View.GotoSlide(x)*, x is your correct/wrong answer slide number.
How to change the font size in msgbox? Thanks
You can't change that through ppt. You'll have to customise the operating system for that.
Hello. Thank you so much. Can you tell me how it works when you make a copy of your presentation? I did and it won't work on the copy. Thanks!
Please make sure that your macros are enabled. Are you by any chance copy pasting the slides or duplicating the .pptm file in its entirety?
@@PPTVBA Mine are enabled I believe. It is a copy of the ppt in its entirety. Is there a way to make a copy of it entirely and still have the score board?
Yep! By just Copy-Pasting the file, the game should still work. I'm not sure why it doesn't work on your end. Can you send me the file via email?
@@PPTVBA yes i will email it to you, thank you so much!
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
is there a way to not show a dialog box for every correct or wrong answer one gets? Instead it is just showed in the last slide where it shows the scores
Just do not type the 'output' command and skip to the 'ActivePresentation' line.
Maybe
Yes. You can remove the MsgBox line.
Excellent! Thanks a lot. I like it. I'm going to use it .
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
Hello Sir, i am a trainer and would like to ask you is there any way that online ppt users can access to this macro based quiz. As far as i know, web based ppt dont have access to macro. please suggest your views
PPT VBA isn't compatible with Web.
Creating a web application for the quiz game would be the best course of action.
why there's no notification when i click the choices?..please help
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.
So i did everything right, but when i insert the macro into a question box, you have to click the right and wrong answer to progress to the next slide. Any solve for this? Thanks!
The question box doesn't have any macros attached to it. Can you please rephrase? I'm unable to understand.
i meant the answer boxes. when i click one, the correct answer msgbox will appear, but the slide won't progress. it only does when i click the wrong answer box as well. sorry for the confusion!
@@gfsadsdf5795 there might be a spelling error in the correct answer sub routine, send the file over to my email and I;ll have a look.
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.
!AWSOME! You are amazing
I'm making a hidden object game using your tutorial to add point. I don't want the 'your answer is correct' box come when I click to the object but I still want the point to be there. Can you help me with that?
Just remove the MsgBox line altogether and it'll work out!
Thanks, you are the best