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.
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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-c2e_SwTC5IY.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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-coSOGwR9CgE.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?
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
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
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, 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 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.
ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Yd5wPOVVG7M.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.
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?
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?
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
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
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 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
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
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!
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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-oGpbLDyjGrY.html where we can send data to excel. It could be helpful for people going through the comments section.
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
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
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?
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*.
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?
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.
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.
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 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! Click on the Points Label, go to the developer options, there is a font category, click on that and you can change the size and the style of the text.
Hello I have created a quiz with 2 options .one is write and one is wrong .no negtive marks added .but facing challange if some click on same answers twice on same slide he is getting double marks for same answers ..please help me
You are amazing! Genius! I need to make some buttons in my quiz and if the answer it's correct, the button will get green, if not, it would get red. It's all working except the final score :'( Please help me! I have the 2007 version Thank you! I SUBSCRIBED!
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.