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

  Рет қаралды 173,099

Bhavesh Shaha - PowerPoint Games

Bhavesh Shaha - PowerPoint Games

Күн бұрын

Download CODE and .pptm file: pptvba.com/powerpoint-quiz-ga...
Add TIMER in your PPT Quiz: • How to add TIME-LIMIT ...
In this Microsoft PowerPoint Tutorial, we will be using Visual Basic Coding (VBA Coding) and making an interactive quiz game that can be used by teachers and in online courses.
We will be adding an instructional slide, six questions. Each question will have four answer options, similar to an MCQ type quiz. In the end, using VBA Coding, we will be able to determine the points scored by the user in this PPT Quiz Game.
==========================================
HOW TO ENABLE DEVELOPER TAB: • Show developer tab in ...
Click the Microsoft Office Button, and then click PowerPoint Options.
Click Popular, and then select the Show Developer tab in the Ribbon check box.
==========================================
Part 1:
I will be showing you how to make an interactive quiz game which can keep scores/points in PowerPoint using Visual Basic or VBA Code.
• How to make PowerPoint...
Part 2:
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.
We will also allow questions to be passed and for the user to retry the quiz game.
• Make PPT Quiz Game Rep...
Part 3:
We will be adding a certificate slide which contains the name and the location of the user. Then, we will be printing the certificate slide and the result slide and save it as a .PDF file.
• Print Certificate with...
==========================================
Be responsible for the next part, comment on any one of my videos for any suggestions that you might have!
Comment below if you have any doubts.
I also do freelancing and make custom powerpoint games and templates. Contact me for more information.
==========================================
00:00 Introduction - PPT Interactive Quiz
00:26 Disabling SlideShow Navigation in PPT Quiz
00:39 Enabling Developer Tab in PPT
01:03 Creating Points Slide in SlideMaster
02:40 Adding VBA Macro Code
05:00 Customing Points Label
06:00 Creating Quiz Game Menu
06:20 Adding Questions
06:56 Adding Macros to Answer Boxes
08:54 Exit Button in PPT Quiz
09:12 Saving Quiz Game as .PPTM (Macro-Enabled)
09:55 Adding Hyperlink in Menu Slide
10:08 Testing the PPT Quiz Game with Points
11:37 Adding Instructions in Menu Slide
==========================================
I also do freelancing, contact me:
🟥 Bhavesh Shaha,
📧 bhavshaha@gmail.com
🌐 www.pptvba.com
🎥 / bhaveshshaha
📷 basicallybhavesh (DMs are open)

Пікірлер: 477
@mariociencia12
@mariociencia12 7 жыл бұрын
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!
@gullwingsyrp88
@gullwingsyrp88 4 жыл бұрын
Love this tutorial, watching this in 2020 after parents are having to teach their children due to school shutdowns because of COVID19. Was trying to figure out how to make learning more fun for my child.
@PPTVBA
@PPTVBA 4 жыл бұрын
Glad to help you out!
@johnbeaubien8826
@johnbeaubien8826 7 жыл бұрын
Well done!! Excellent work! I highly recommend these tutorials - you have a fan in Manitoba Canada :)
@lakshmanank7256
@lakshmanank7256 5 жыл бұрын
In 12 minutes, you explained it all :-). Thank you.
@parcival
@parcival 7 жыл бұрын
This video is really well done. Thank you for your contribution! You are a great teacher!
@AdaKoppejan
@AdaKoppejan 7 жыл бұрын
This was fantastic - so helpful!
@arvindjanardhan2173
@arvindjanardhan2173 6 жыл бұрын
Amazing, U are amazing, have made multiple quizzes using this format
@ebishirl
@ebishirl 7 жыл бұрын
Brilliant tutorial, thank you! It took me a few tries, but is working great now.
@sesughdangi4674
@sesughdangi4674 2 жыл бұрын
My name is Ambrose from Nigeria. I just discovered this channel when I wanted to build a game show for my children. Coming this has changed my classroom and quizz experience completely. Thanks so much and I look forward for giving in my little support to this channel as soon as possible.
@PPTVBA
@PPTVBA 2 жыл бұрын
Thank you so much for your kind words!
@user-jj6vz3nk8m
@user-jj6vz3nk8m 8 ай бұрын
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
@tanisha8520
@tanisha8520 5 жыл бұрын
Thank you, this was really helpful!
@djafmess4008
@djafmess4008 4 жыл бұрын
Thank you so much. I downloaded your presentation & modified it to match my students' needs.
@abhianvnepal8922
@abhianvnepal8922 7 жыл бұрын
you taught me very nicely so i have subscribed and liked - well done
@alexneves7809
@alexneves7809 5 жыл бұрын
ok did it again, and downloaded your templates. Thank you so much it's just what I needed for my lessons. :-)
@menardsoriano603
@menardsoriano603 7 жыл бұрын
Thank you very much!!! This is very helpful!!!
@brahimachtbi3351
@brahimachtbi3351 7 жыл бұрын
Thanks a lot. Very informative indeed.
@louis-fredericktelot9901
@louis-fredericktelot9901 6 жыл бұрын
Thanks for your video. Very clear explanations.
@fishbloke100
@fishbloke100 7 жыл бұрын
Thankyou Bhavesh it works it is so easy when you know how
@cosmin230
@cosmin230 7 жыл бұрын
thx buddy it helped me a lot at scholl
@tehmalayspartan
@tehmalayspartan 7 жыл бұрын
I'm very impressed. Keep up the good work! :)
@israelcudia
@israelcudia 4 жыл бұрын
May 5 2020.... man.. you are the best... more power from Philippines
@PPTVBA
@PPTVBA 4 жыл бұрын
Thank you very much!
@shonellamorgan1867
@shonellamorgan1867 4 жыл бұрын
This is soooo awesome!!! Thanks for sharing. This helped me with my assignment. I was getting so frustrated because I have an assignment and did not know what to do. Thanks again
@PPTVBA
@PPTVBA 4 жыл бұрын
Glad i could help you out!
@gonzalobernalferreira3870
@gonzalobernalferreira3870 4 жыл бұрын
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
@PPTVBA 4 жыл бұрын
Thank you very much!
@ookii654
@ookii654 3 жыл бұрын
Thank you!!! Great Video!! Will be making my own quizzes for my kids now!!!
@PPTVBA
@PPTVBA 3 жыл бұрын
That's amazing to hear! Glad you liked the tutorial! I have more ppt game tutorials too! Do check em out!
@orlandomurcia4924
@orlandomurcia4924 4 жыл бұрын
Excellent! Thanks a lot. I like it. I'm going to use it .
@jitendrabomble2218
@jitendrabomble2218 4 жыл бұрын
Very nice videos of ppt. Thanks !!! Please upload More videos of VBA Course 👌👌👌
@Checkagile
@Checkagile 5 жыл бұрын
Good One. Thank for the details
@Waitxn
@Waitxn 2 жыл бұрын
Literally the best tutorial out there.
@PPTVBA
@PPTVBA Жыл бұрын
Thank you for your kind words!
@bejai1962
@bejai1962 6 жыл бұрын
I have been searching and searching for help on how to do this. Thank you so much for a clear, easy to follow explanation!!
@PPTVBA
@PPTVBA 6 жыл бұрын
Thank you very much for your appreciation. I also have more parts regarding this, in which I add percentage, non of correct and incorrect answer etc. It is in the description.
@bejai1962
@bejai1962 6 жыл бұрын
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
@shivamraut1252
@shivamraut1252 2 жыл бұрын
You are Awesome Bhavesh ... loved your video...
@anilkodakkadan
@anilkodakkadan 5 жыл бұрын
very informative and innovative.... thanks
@applekyeopta2761
@applekyeopta2761 4 жыл бұрын
thanks for this. it really a great help for me since I have a problem in scoring part of the game ♥
@paramananthensivakolunthu2876
@paramananthensivakolunthu2876 3 жыл бұрын
Exellent explanation. Thnaking you.
@sagarrao781013
@sagarrao781013 7 жыл бұрын
extremely thankful for this video, was working on an assignment to make an interactive quiz and was stuck at the scores/ points part
@kazimrahman7499
@kazimrahman7499 2 жыл бұрын
Awesome....looking forward for more something new.
@rajavarmanslb3745
@rajavarmanslb3745 4 жыл бұрын
very useful for multiple choice questions Thanks lot
@infoworld3091
@infoworld3091 4 жыл бұрын
Very good tutorial. Thanks
@jenkostation
@jenkostation Жыл бұрын
This is excellent tutorial! Thank you very much :)
@PPTVBA
@PPTVBA Жыл бұрын
Glad it was helpful!
@sasikalam1531
@sasikalam1531 5 жыл бұрын
Clearly explained, thanks bhavesh
@PPTVBA
@PPTVBA 5 жыл бұрын
Thank you very much. I have also made more parts in which you can add percentages at the end of the slide.
@pbrmgrbibhoal
@pbrmgrbibhoal 7 жыл бұрын
Good it is very useful and clear.
@yosefnedjar8870
@yosefnedjar8870 6 жыл бұрын
!AWSOME! You are amazing
@geetikakapoor1426
@geetikakapoor1426 7 жыл бұрын
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?
@dhavaldwivedi
@dhavaldwivedi 7 жыл бұрын
Very useful tutorial
@karlnikolasalcala8208
@karlnikolasalcala8208 4 жыл бұрын
THIS IS AMAZING!!! WHY HAVEN'T I DISCOVERED IT EARLIER !! today is 2020 btw
@PPTVBA
@PPTVBA 4 жыл бұрын
YOURE IN FOR A TREAT THEN! POWERPOINT VBA IS LOVE AHAHAH
@d.i.a.5392
@d.i.a.5392 4 жыл бұрын
Same here. I had no idea about these properties of ppt :)
@PPTVBA
@PPTVBA 4 жыл бұрын
Glad to have you all on board to the PPT VBA train !
@alexneves7809
@alexneves7809 5 жыл бұрын
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?
@peavee69
@peavee69 7 жыл бұрын
awesome work buddy, very impressed
@vaniagrawal4142
@vaniagrawal4142 2 жыл бұрын
Thank you! 2016 Bhavesh AND 2021 Bhavesh were very helpful.
@PPTVBA
@PPTVBA 2 жыл бұрын
2016 Bhavesh is ecstatic that someone as awesome as you is my best friend. 2021 Bhavesh is laughing that you spelt MsgBox as MagBox.
@jullalexcalmorin9659
@jullalexcalmorin9659 5 жыл бұрын
thank you so much, big help to me
@rossettydolly3085
@rossettydolly3085 3 жыл бұрын
Thank you so much Bhavesh! You help a lot in my assignment..
@PPTVBA
@PPTVBA 3 жыл бұрын
Glad to hear that! This ppt quiz tutorial series have more 6 parts too!
@timeaturai7126
@timeaturai7126 Жыл бұрын
this is awesome 😀
@alisadti5491
@alisadti5491 4 жыл бұрын
it's very usefull thanks alot
@ruthbrillo4751
@ruthbrillo4751 5 жыл бұрын
nice! thanks for having this video. Very helpful. God bless!
@PPTVBA
@PPTVBA 5 жыл бұрын
Thank you very much!
@qamarjaunpuri4168
@qamarjaunpuri4168 4 жыл бұрын
Brilliant. Very good job. Keep it up.
@PPTVBA
@PPTVBA 4 жыл бұрын
Dhanyavad!
@melanioflorino5674
@melanioflorino5674 4 жыл бұрын
Thank you very much, Sir. My salute to you. This is very helpful. From Philippines here.
@PPTVBA
@PPTVBA 4 жыл бұрын
Glad to help!
@PPTVBA
@PPTVBA 4 жыл бұрын
Glad to help!
@ssmailhr
@ssmailhr 7 жыл бұрын
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
@sanjanasanju6507
@sanjanasanju6507 4 жыл бұрын
Thank you soo much
@karmenmott9229
@karmenmott9229 4 жыл бұрын
Thank Your very much, this was really amazing and halpful
@PPTVBA
@PPTVBA 4 жыл бұрын
Glad to help! I have another video where you make a report card with the quiz resutls
@joseemiliobacaniklas7654
@joseemiliobacaniklas7654 7 жыл бұрын
hi, muy buenos los videos.. interesantes. gracias por compartirlos
@PPTVBA
@PPTVBA 7 жыл бұрын
muchas gracias :)
@sweswelattdr2964
@sweswelattdr2964 6 жыл бұрын
thanks a lot for your sharing it
@rinalugatiman2520
@rinalugatiman2520 3 жыл бұрын
Thank you so much! It really helps a lot. GBU
@PPTVBA
@PPTVBA 3 жыл бұрын
Glad the PowerPoint Quiz Game helped you out!
@abounarimanedriouch161
@abounarimanedriouch161 4 жыл бұрын
Merci beaucoup
@princeyahwetv
@princeyahwetv 5 жыл бұрын
Amazing
@jlmagz4560
@jlmagz4560 3 жыл бұрын
tnx for the help.. God bless
@banaarsyntax577
@banaarsyntax577 4 жыл бұрын
Ammmmmazing.. keep it up.. and your voice is soooo sweet.. god bless.
@PPTVBA
@PPTVBA 4 жыл бұрын
Ahaha thanks a lot! This video was upload a long time back! Please do watch the entire playlist!
@messaoudacherif2635
@messaoudacherif2635 4 жыл бұрын
thanks a lot
@AymanAfifyAhmed
@AymanAfifyAhmed 7 жыл бұрын
I subscribed:) because of ur awesome video
@PPTVBA
@PPTVBA 7 жыл бұрын
Thank you :)
@bridgetgainous5487
@bridgetgainous5487 6 жыл бұрын
I love this. Is there a way to have points for more than one player? I am a teacher, and I like to have the students play with teams.
@PPTVBA
@PPTVBA 6 жыл бұрын
kzbin.info/www/bejne/j5WYqIOFi7t6ba8 yes! I made this one for a teacher. Please tell me if you need something of that sort. My email is 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).
@bridgetgainous5487
@bridgetgainous5487 6 жыл бұрын
Bhavesh Shaha Yes, this video was perfect. I will email you after I try to make my quiz. My kids like to keep team points.
@PPTVBA
@PPTVBA 6 жыл бұрын
Yeah that'd be great. I also do freelancing and you can also purchase the full version with custom designs and animations as per your choice for a very small fee. Thank you!
@surbhigoel4869
@surbhigoel4869 4 жыл бұрын
If You guys find out a way for team Work do let me know!
@sciencepowerpoints
@sciencepowerpoints 4 жыл бұрын
Hey, will an macro enabled powerpoint also work if you upload in Google slides (upload Powerpointpresentation) in google slides
@PPTVBA
@PPTVBA 4 жыл бұрын
Sorry, VBA Macros do not work in google slides.
@MyShand
@MyShand 4 жыл бұрын
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
@sheetsofcotton
@sheetsofcotton 4 жыл бұрын
This is very helpful! Is there a way to do this quiz with multiple correct answers?
@anissofia2332
@anissofia2332 3 жыл бұрын
For the sake of getting an A for my CALL Assignment, I’ll be using your idea. You are indeed a genius! Thank you for sharing 🤍🤍🤍
@PPTVBA
@PPTVBA 3 жыл бұрын
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.
@anissofia2332
@anissofia2332 3 жыл бұрын
@@PPTVBA I’ve subscribed you, I’ll check it out soon! God bless you in whatever you do 🥺🙏🏼✨
@PPTVBA
@PPTVBA 3 жыл бұрын
@@anissofia2332 ay thank you xD
@anissofia2332
@anissofia2332 3 жыл бұрын
@@PPTVBA sir, why if we save our point point to power point macro enabled show, we cannot write the answers in fill in the blank activity. It must be saved for pp macro enabled presentation hmmmmmm
@PPTVBA
@PPTVBA 3 жыл бұрын
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.
@bibintharian4093
@bibintharian4093 4 жыл бұрын
You are doing great. I am using it for my blogger
@PPTVBA
@PPTVBA 4 жыл бұрын
What is your blogger site?
@bibintharian4093
@bibintharian4093 4 жыл бұрын
@@PPTVBA bktmexfeed.blogspot.com/
@bibintharian4093
@bibintharian4093 4 жыл бұрын
First I want to add the provision for skipping the question. Just like a exam... Anyway you are doing a great job.... Can I use your material with your permission?
@PPTVBA
@PPTVBA 4 жыл бұрын
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.
@itsmejustletmein
@itsmejustletmein 5 жыл бұрын
Great video! Thanks. Have you made a tutorial on adding music and sound effects?
@PPTVBA
@PPTVBA 5 жыл бұрын
I'll be certainly making one on this real soon. Thank you for suggesting.
@Hasan-bc6rr
@Hasan-bc6rr 2 жыл бұрын
This was great, I love your step-by-step explanation. How can I put the scorekeeping widget on every slide so it is always visible as I answer all the questions? I could not just copy it over to other slides. thanks
@PPTVBA
@PPTVBA Жыл бұрын
Hi! You can change the slide-layout of all the question slides to the one that has the Scoreboard on it!
@itworks9368
@itworks9368 2 жыл бұрын
Hi, Is there anyway to initiate a shape animation with VBA?
@cotisoft2444
@cotisoft2444 3 жыл бұрын
Hey, you have helped me a lot in my game, but I have one question. Can you tell me if there is a code to ActivePresentation.SlideShowWindow.View.GotoSlide (...), that fixes the slide and there is no point changing the code again and again if you add slides?
@PPTVBA
@PPTVBA 3 жыл бұрын
stackoverflow.com/questions/65147457/navigate-to-ppt-slide-by-its-id-or-name-instead-of-number Check this out.
@cotisoft2444
@cotisoft2444 3 жыл бұрын
@@PPTVBA Thank you man!
@mikeyjrful23
@mikeyjrful23 6 жыл бұрын
Hi Bhavesh! I just recently saw your video and this tutorial was amazing. Thank you so much! I have teams for the powerpoint game I am using and I want to add or subtract points to each team. If there is a way to do this, I would really appreciate it :D
@PPTVBA
@PPTVBA 6 жыл бұрын
kzbin.info/www/bejne/aYjFe3Z9pLitnrc This video is what you would need. XD THANKS A TON :D
@mikeyjrful23
@mikeyjrful23 6 жыл бұрын
Thanks again! :)
@nooraniyaenglishschoolrajk1811
@nooraniyaenglishschoolrajk1811 6 жыл бұрын
Hi Bhavesh... Good Work... Keep it up... Really very useful.... Can you also provide coding for scoring along with time line... ???
@PPTVBA
@PPTVBA 6 жыл бұрын
"Scoring along with time line..." Wait. What? I'm unable to understand your query.
@vmili8589
@vmili8589 4 жыл бұрын
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?
@PPTVBA
@PPTVBA 4 жыл бұрын
kzbin.info/www/bejne/pXjTk396rs96qLs Here is a tutorial!
@enjolijimenez3858
@enjolijimenez3858 5 жыл бұрын
Hi! This is a very good tutorial! I am a little nervous to try it out for what I need it for and wanted to ask your thoughts. I am a preschool director and I must give baseline testing to all the children; however, our learning goals are not like other schools so a regular test does not work well for our needs. Do you think I can add shapes and colors, etc. for the students to visually see the question since they are not reading at this age? Also, for a beginner , how long do you think it will take me to create something specifically for my school? Lastly, are you available for higher? Honestly we do not have very big budgets at my school; however, I would like to know if this is something you could create for us. Kind regards, and thank you again for the post.
@PPTVBA
@PPTVBA 5 жыл бұрын
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.
@PPTVBA
@PPTVBA 5 жыл бұрын
I haven't heard back from you. Are you still interested?
@saritassinan
@saritassinan 3 жыл бұрын
Teşekkürler.
@mokhatri4146
@mokhatri4146 4 жыл бұрын
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
@PPTVBA 4 жыл бұрын
Yes we totally can! Please send me your file and I can have a look at the errors.
@rajnimonga1628
@rajnimonga1628 3 жыл бұрын
@@PPTVBA Hi. I am facing the same issue. Could you please share how you corrected the issue. Also, when I click on the correct or incorrect options, the dialog box doesn't appear.
@PPTVBA
@PPTVBA 3 жыл бұрын
@@rajnimonga1628 we just have to fix the variables to match the new presentation. We cannot copy paste it per se. You can send the file to me and I can have a look at it and suggest the changes.
@rajnimonga1628
@rajnimonga1628 3 жыл бұрын
@@PPTVBA Thank you for the prompt reply. I have shared the ppt with you via Gmail.
@tessnorman
@tessnorman 6 жыл бұрын
Thank you so much for this tutorial! Amazing job! Subscribed and liked. Do you know if it's possible to run this on a tablet? It works perfectly on my computer but the macro doesn't work on my tablet. I have a Samsung Galaxy Tab A.
@PPTVBA
@PPTVBA 6 жыл бұрын
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.
@tessnorman
@tessnorman 6 жыл бұрын
Thank you so much for your reply! I ended up making this quiz game for an event at work and everybody loved it, including my boss =) Just did it on my computer which was good. Please make the tutorial on the android game! That would be awesome. =) Which coding language do you use for that, is it Javascript? And thanks for your contact, I will for sure hit you up when the need arises at work. Best, Therese
@PPTVBA
@PPTVBA 6 жыл бұрын
Glad to hear that the event was a success! Alright, I'll be making for mobile real soon! Yes, JavaScript is used for that.
@marcosisto1260
@marcosisto1260 3 жыл бұрын
hi! Could you tell me why we have to create a slide master? Can't we put the code in a normal slide?
@PPTVBA
@PPTVBA 3 жыл бұрын
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.
@mariemloghmari8662
@mariemloghmari8662 5 жыл бұрын
Very well explained thank you so much ! Is there a way to add a countdown that will automatically stops the quiz after 20 min? And is there a way to send the score with student's name in another excel spreadsheet? That would be super helpful !
@PPTVBA
@PPTVBA 5 жыл бұрын
Yeah! There is a way to sent the results in a spread sheet. I'm not sure about the 20 minute timer though. I know of a way to add individual timers for each question. I'll make the excel video by this week.
@mariemloghmari8662
@mariemloghmari8662 5 жыл бұрын
Bhavesh Shaha amazing ! Thank you so much ! If there is not a way to add a countdown, is there a way to add in the excel spreadsheet as well as in the PowerPoint how many minutes the student took to do the test ? And one last thing if possible, could you please show how to do an automatic ranking in the excel spreadsheet with the best score ? And maybe at the end of the score a kind of : TADADADA ring, to show results 😂 just to make it funnier hahaha (Even if you showed us half of it I would be forever grateful !) That would be literally a BLESSING ! Have a nice day ! And can’t wait to see the video coming !
@PPTVBA
@PPTVBA 4 жыл бұрын
I know that you do not require this feature because this comment is long due but I release the tutorial: kzbin.info/www/bejne/pXjTk396rs96qLs where we can send data to excel. It could be helpful for people going through the comments section.
@user-bs1yt6oj1c
@user-bs1yt6oj1c 7 жыл бұрын
Thanks for your nice tutorial. It helps me learn. Can you tell me what the purpose of the parentheses is in this line of your code: Points.Caption = (Points.Caption) + 10
@PPTVBA
@PPTVBA 5 жыл бұрын
By adding parentheses, it assumes it to be a number instead of text. For eg: 5 + 10 = 510, (5) + 10 = 15.
@helloeaes5701
@helloeaes5701 3 жыл бұрын
amazing tutorial! just asking if there would be a way to make the player win if they get 3 or more points and lose if they get anything below 3?
@PPTVBA
@PPTVBA 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?
@helloeaes5701
@helloeaes5701 3 жыл бұрын
cool! i have an end screen, and i would like a text box on the screen to say that you won when you get 3 or more, or say that you lost when you get less than 3
@PPTVBA
@PPTVBA 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.
@mariaceciliapagana3228
@mariaceciliapagana3228 6 жыл бұрын
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.
@PPTVBA
@PPTVBA 6 жыл бұрын
Have you saved the file in the correct format? Save as .pptm not .ppt
@enikomihaly1842
@enikomihaly1842 2 жыл бұрын
Hello and a big thank you for your explanation. I have a question. Can these games be used online?
@PPTVBA
@PPTVBA Жыл бұрын
Unfortunately VBA is compatible only with the offline PowerPoint Application in Windows and MacOS.
@divyanshjain4957
@divyanshjain4957 3 жыл бұрын
Sir which theme or template you have used
@princeyahwetv
@princeyahwetv 5 жыл бұрын
interesting I'll make this in my research
@PPTVBA
@PPTVBA 5 жыл бұрын
I wish you all the best!
@princeyahwetv
@princeyahwetv 5 жыл бұрын
@@PPTVBA please sub me back ,,,thank you
@PPTVBA
@PPTVBA 5 жыл бұрын
@@princeyahwetv alright
@shonellamorgan1867
@shonellamorgan1867 4 жыл бұрын
Hello, thanks for sharing your videos. They are really helping me out with my school projects. The only thing though is that I do not understand how to code VBA if I want to do something else. Which brings me to asking you two questions: Could you show how to do drag and drop game? I created the game, but do not know how to code it. 2. I attempted a do a Form with a Submit button and trying to link to xls but not doing well there either. It is saying "Sub or Function not defined for the form. I do not know what I am doing wrong. I have one last project for school for its semester, so that is why I am trying so hard, but the coding part is 'beating me'. Here is the code I did for the Form. Please tell me what it is that I am doing wrong. Thanks in advance. I have First Name; Last Name and Number of year? And the respondent has to click either 1-11 or 11 and over in the checkbox Private Sub CmdSubmit_Click() Dim emptyRow As Long 'Make Sheet1 active Sheet1.Activate 'Determine emptyRow emptyRow = WorksheetFunction.CountA(worksheet1("A:A")) + 1 'Transfer information Cells(emptyRow, 1).Value = TxtFirstName.Value Cells(emptyRow, 2).Value = TxtLastName.Value Cells(emptyRow, 3).Value = Tbxnumberofyears.Value If ChoiceButton1 - 11 = True Then Cells(emptyRow, 3).Value = "1-11" Else Cells(emptyRow, 3).Value = "11 & Over" End If End Sub End Sub
@PPTVBA
@PPTVBA 4 жыл бұрын
1. I am not sure about a drag-and-drop game. I have no idea where to even start from sadly. I would love it if you could share any resources which you might have come across whilst browsing. 2. You haven't set an Object for the Excel Application. Check my video where I send PPT Quiz Results to Excel. That will help you with the coding.
@shonellamorgan1867
@shonellamorgan1867 4 жыл бұрын
@@PPTVBA Thanks for replying. You may check this one out. kzbin.info/www/bejne/o3qoo2uql7SNrdk. I do not understand how the person did it though. But this is the perfect one I would like to know how to do it for my school project. Also, you could check out these, kzbin.info/www/bejne/i4SneHt3pNN1ea8; kzbin.info/www/bejne/fqqXeZyvaZykbqM; kzbin.info/www/bejne/j5uvaYWXdqqMgpY let me know if after viewing if you are maybe able to do it. Thanks.
@PPTVBA
@PPTVBA 4 жыл бұрын
I'll look into those and get back to you!
@arvindjanardhan2173
@arvindjanardhan2173 6 жыл бұрын
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?
@PPTVBA
@PPTVBA 6 жыл бұрын
You can try removing the pop up message. How about adding a sound to indicate whether the answer was correct or incorrect?
@ride-vgaming8356
@ride-vgaming8356 4 жыл бұрын
@Arvind Janardhan you should enable the 'play across the slides' option in the music properties
@PPTVBA
@PPTVBA 4 жыл бұрын
I had tested that too but for me, the music stops when ever a MsgBox pops up.
@nikoamplayo5438
@nikoamplayo5438 3 жыл бұрын
It is applicable when 2 questions are in a single slide? Cause 1 click is automatically skip to the next slide. How when 1 slide is 2 multiple questions and answers.
@PPTVBA
@PPTVBA 3 жыл бұрын
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*.
@PPTVBA
@PPTVBA 7 жыл бұрын
Part 2: kzbin.info/www/bejne/mWPIkIatiahof7s 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: kzbin.info/www/bejne/maC2gHqth552nac
@jastinejakerangis8548
@jastinejakerangis8548 6 жыл бұрын
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?
@PPTVBA
@PPTVBA 6 жыл бұрын
Everything is in the description. Sorry for the late reply.
@PPTVBA
@PPTVBA 5 жыл бұрын
Please try downloading the file given in the description. Make sure your macro security is enabled. Check if the sample file works.
@ashleyn.3872
@ashleyn.3872 5 жыл бұрын
+Bhavesh Shaha okay, I'll check right now
@SanjeevaKumarSahu
@SanjeevaKumarSahu 5 жыл бұрын
bhai link nahi hai
@judenetto7248
@judenetto7248 3 жыл бұрын
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
@PPTVBA
@PPTVBA 3 жыл бұрын
PPT VBA isn't compatible with Web. Creating a web application for the quiz game would be the best course of action.
@bigman6637
@bigman6637 7 жыл бұрын
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
@PPTVBA
@PPTVBA 7 жыл бұрын
stackoverflow.com/questions/43708372/how-to-add-delay-before-going-to-next-slide-in-ppt-using-vba
@sujathamaddula731
@sujathamaddula731 3 жыл бұрын
Is it possible for have more than one correct answer and score the points?
@alawiali53
@alawiali53 3 жыл бұрын
Nice video, but I have a question if there are 6 persons that will do the quiz and I need that they write their name cause to know the results for each one of them so how I can do it ?
@PPTVBA
@PPTVBA 3 жыл бұрын
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.
@shankarmidatala2049
@shankarmidatala2049 5 жыл бұрын
Hi Bhavesh, Thanks for this wonderful tutorial. I'm able to follow your instructions and make a PPT based Quiz with scores and its working awesome. I've a question: how to increase the font size of the message like "Correct Answer" or "Wrong Answer" and is it also possible to add music on clicking the Correct answer and a different music on clicking the Wrong answer. Please help.
@PPTVBA
@PPTVBA 5 жыл бұрын
1. Yes. Music can certainly be added. Click the shape, go to insert > actions > mouse click > play sound. 2. If you reduce the resolution of your monitor, the message box should become bigger. Another way to implement your idea is by typing that in the slide and making that appear with the help of animation triggers.
@PPTVBA
@PPTVBA 5 жыл бұрын
There's another method to do that too. We can make a UserForm and use that as a messagebox.
Make PPT Quiz Game Report Card - percentages, no. of correct answers | PPT VBA Macro Tutorial
9:01
Пробую самое сладкое вещество во Вселенной
00:41
Каха и суп
00:39
К-Media
Рет қаралды 3,6 МЛН
Print Certificate with student's NAME | Interactive Quiz Game: PPT VBA Macro Tutorial
20:39
Bhavesh Shaha - PowerPoint Games
Рет қаралды 15 М.
Interactive True-or-False QUIZ GAME in PowerPoint | Download Free  PowerPoint Quiz Template
11:40
Bhavesh Shaha - PowerPoint Games
Рет қаралды 57 М.
Creative Text Trick in PowerPoint
1:00
Presentation Process
Рет қаралды 646 М.
Creating Quiz Games with Scores in PowerPoint (Windows)
20:05
Wanda Adams
Рет қаралды 4,1 М.
Connect EXCEL and PPT to Import Questions & Send Report Card [PowerPoint VBA Quiz Game Tutorial]
11:08
How to Make a Scoreboard in Powerpoint
15:34
MrBoverC
Рет қаралды 14 М.
PowerPoint Quiz Game - Who Wants To Be a Millionaire - (Free Download PPT Template)
19:21
Bhavesh Shaha - PowerPoint Games
Рет қаралды 138 М.
🤣МАЛО КУПИТЬ ЛОШАДЬ
0:18
Бутылочка
Рет қаралды 6 МЛН
رورو ضد رقيه🔫😲🚀 #shorts
0:13
رورو فاميلي | Roro Family
Рет қаралды 34 МЛН