Connect EXCEL and PPT to Import Questions & Send Report Card [PowerPoint VBA Quiz Game Tutorial]

Let's learn to Populate, Import, Generate a Microsoft PowerPoint Interactive Quiz From Microsoft Excel With VBA - Visual Basic Application.
VBA Code: pptvba.com/import-ppt-quiz-ex...
POPULATE A POWERPOINT QUIZ FROM EXCEL WITH VBA
Import Questions & Answers of a Microsoft PowerPoint Multiple-Choice Quiz Game from Excel with VBA.
0:00 Introduction
0:25 Import Questions & Answers from Excel
6:49 Export and Send Results to Excel
After this, you can also shuffle the answer boxes so that they are placed in random positions, learn how: • How to Randomly Shuffl...
We can automatically generate a PowerPoint Quiz Game whilst using Microsoft Excel as our database. We can type the questions and answers in pre-set columns, then using VBA in PowerPoint we can populate our Question Slides.
We run the following ImportQuestions sub-routine to populate our PowerPoint Quiz Game. We first set the location of the Excel Workbook that is already created in the same folder as the PowerPoint Quiz Game.
Our columns are preset with the data that is supposed to be present. The A Column has only the questions, the B Column has only the correct answer, the columns from C to E only have the wrong answers.
This later allows us to call to the values present in the Excel Cells of those Columns and use them to populate all the Question and Answer Shapes of the PowerPoint Quiz.
We use a For-Loop for all the question slides. This allows us to populate all the question slides with the necessary questions and answers.
Do note that the names of the shape in PowerPoint are case-sensitive. Also, change the variable range in the for-loop based on the number of slides in your PowerPoint Quiz Game.
The biggest question now is that if we duplicate the slides and import the questions from an Excel Sheet, the answers will not be shuffled and the order and the position would remain the same. Worry not!
Learn to randomly shuffle the PowerPoint Answer Shapes:
pptvba.com/ppt-quiz-random-sh...
EQUIPMENT: This video contains affiliate links. If you click on one of them, I'll receive a commission
💻Laptop: amzn.to/2BvJ1Cp (Dell XPS 15)
🎙Microphone: amzn.to/38jdVtK (Zoom H1n)
💿Software: Camtasia Studio
Intro Music: Dock Rock (Sting) - John Deley and the 41 Players
Outro Music: Yo Picasso - Verified Picasso
#PowerPointGames #PowerPointTutorial #PPTVBA
I also do freelancing, contact me:
🟥 Bhavesh Shaha,
📧 [e-mail]
🌐 www.pptvba.com
🎥 / bhaveshshaha
📷 basicallybhavesh (DMs are open)

[@PPTVBA]

Part 1 : kzbin.info/www/bejne/iZfHgapra86lpZo 0:00 Introduction 0:25 Import Questions & Answers from Excel 6:49 Export and Send Results to Excel After this, you can also shuffle the answer boxes so that they are placed in random positions, learn how: kzbin.info/www/bejne/jqaadautr56brsk

[@motamayizz]

TNKS SO MUCH YOU ARE AMAZING I WWENT TO LEARN SO MUCH ABOUT VA POWERPOINT

[@MarisolRamos-1971]

Tu trabajo es excelente. Gracias 😆

[@kazimrahman7499]

Awesome....looking forward for more exciting VBA project....Thanks.

[@rameshks8449]

Very useful and nice tutoring. Thanks

[@motamayizz]

this is amazing tank you

[@hamzamottali3567]

hey my friend, i don't try it yet, but I have a question for the excel file Generated, if I have more questions and if I generated the results more than once, it will be the same file or it generate new file all time ?

[@ktelopalec2631]

Hello Master, thanks for the video :) Can you also teach me how did you made the "Next" button show after selecting the answer? Thank you so much!

[@PPTVBA]

Heya! Do check the part 1 of this video that is on my channel! I'll send a link here too: kzbin.info/www/bejne/iZfHgapra86lpZo

[@azdarkarts4090]

can you make a drag and drop image in VBA PowerPoint?

[@adi-rg3yf]

hey bro now are u able to open that "data" excel file

[@houdinisafetytraining9632]

Hi, Great Video! Can this work if I uploaded on Sharepoint for others to take?

[@PPTVBA]

Hi! Unfortunately VBA works only in the offline version of the PowerPoint Application in either Windows or MacOS. So, if the user downloads it into their system, it would work.

[@thptquocgiatienganh]

Can I select certain slides, for example, odd slides (1,3,5,7...) to import questions only?

[@PPTVBA]

Yes! Use this line of code instead of what is originally present: For i = 2 to ActivePresentation.Slides.Count Step 2. The Step 2 skips a number in between.

[@binhojulio3437]

hello great stuff congratulations, how can i save in a single excel file? and how can i start the game in presentation mode?

[@PPTVBA]

Hello! You can save the game in .ppsm format for it to open automatically in slide show mode. Regarding the single excel sheet, we would have to change few lines in the code to open an existing Excel file and update that. I'll try to make a video on that or update my webpage.

[@adi-rg3yf]

hey bro , Here according to your work all correct answers are in shape ("a1"'), right. Then u said to shuffle them by seeing your earlier tutorial , but if we shuffle options in that. manner , then "a1" shapes of every slides are going to be in same position, and "a2" shapes are going to another same position, and same with shapes "a3" and "a4". It means if 1st question slide has correct option in 2nd position , then all other questions slide will also have correct option in 2nd position. So, is there any solution to overcome this problem ?

[@PPTVBA]

Yes! This was an issue that I faced, I was able to fix this by having the `For i = 3 to 8` above the codes that shuffled the array. In my video tutorial, the array is shuffled only once and all the question slides follow that format. However, I changed the code, new code available in my website: pptvba.com/ppt-quiz-random-shuffle/ and I've added an explanation there too! I hope that helps! Thank you.

[@adi-rg3yf]

@@PPTVBA thank u

[@motamayizz]

HI TNKS A LOTS AM LOKKING FOR THIS I HAVE QUESTION PLS HOW CAN I DO SAME THINK BUT WHIT SLIDE MASTER PLIIIIIIIIIIZ

[@PPTVBA]

In my *Make Certificate for PPT Quiz Game*, I show how to change the text of a TextBox shape present in a slidemaster. Please refer to that video and extrapolate the codes accordingly.

[@motamayizz]

@@PPTVBA tnks a lot I saw the video and I like it am looking to how to send information in sheet excel to slide master in PowerPoint code tanks again

[@PPTVBA]

Instead of ActivePresentation.Slides().Shapes, use the code used to refer to the CName in that video.

[@ltnedu.]

Excel file in not modify how to edit question?

[@PPTVBA]

Delete the excel file and make a new one.

[@adi-rg3yf]

hey bro how to transfer text from table (in ppt only) to text box

[@PPTVBA]

I don't remember the code right away. For the shape it is the .TextRange property, for the table, if I recall, we need to have the .Cell and choose the column and the row, and then use .Shape.TextFrame.TextRange. Do check the Microsoft documentation or Stack Overflow.

[@adi-rg3yf]

@@PPTVBA thanks a lot but if u don't mind, can u just type an example?

[@adi-rg3yf]

ok OK I got it from Microsoft documentation website thanks a lot.✌ 💕waiting for your next vid.

[@vipinac123]

i dont have any coding experience how can i learn this kind of coding

[@PPTVBA]

Just follow along and watch multiple VBA Tutorials! You'll get the gist after a while automatically!

[@jarrett_julut_3692]

Hi may i know what to do if the error says "run time error 424" object require? Im know sure whether or not if its the file location's problem or something else.

[@jarrett_julut_3692]

I also did follow every step of this video so I dont think its the code that has the problem. Just the file location or whatever object it means.

[@PPTVBA]

Confirm if all the instances in the code (file name, slide name) are case sensitive. If errors still persist, email me the file [e-mail]. Also, connecting PPT and Excel works only on Windows and not on MacOS.

[@jarrett_julut_3692]

@@PPTVBA okay thank you sir XD

[@backhistory9707]

I don't see the link for SendResults.

[@PPTVBA]

kzbin.info/www/bejne/pXjTk396rs96qLs Here's the video that shows how to send results to excel.

[@backhistory9707]

@@PPTVBA i saw also that you randomize the answers here. Can you show me the code?

[@PPTVBA]

kzbin.info/www/bejne/jqaadautr56brsk Here's the video that shows how the answer order was shuffled. The codes are present there! Thanks.

[@joysworldandlifestyle9679]

nice vidio like, joind your sweet ch7 hope u enjoy mine