Print Certificate with student's NAME | Interactive Quiz Game: PPT VBA Macro Tutorial

[@gansee3782]

Thanks for sharing and providing such a clear and good guidance in creating games.

[@gansee3782]

I never thought of myself is able to understand the code or script in macro or visual basic, not even in power point. Your tutorial really help me to understand the script or code better though i am just a beginner with no knowledge of the script or code at all. The explanation and workflow conducted in the tutorial are very useful and at the right pace for me to follow. I have really learned and picked up the skill at least to create interactive games in power point after watching a few tutorial from the same source online. Many thanks again to make life a lot more interesting with learning online as guided by your team.

[@PPTVBA]

Timestamps: (damn it became 20 minutes) 1. Making Certificate Slide: 00:33 2. Adding input textbox (name, location) and coding : 04:13 3. Adding 'Print Certificate' button: 08:31 4. Mention location of an element in VBA: 09:40 5. Exporting Certificate slide as .pdf: 11:15 6. Testing the game: 15:00 7. Debugging (minimizing the window and removing decimals in %): 16:18 8. Printing Certificate only if % > 50%: 17:04 9. Clearing the input textbox: 17:56 10. Testing the game: 19:28

[@nuviaaguilar3379]

Hi. Thank you for such a nice support! I want to save slides 1 to 10 and also 12 but not 11. What code do I need in such case? Appreciate your help in advance.

[@seemamunshi9533]

Very nicely explained Bhavesh . Thank you so much

[@azizmamat]

Alhamdulillah, terbaik. Saya dari Malaysia, Sir Bhavesh.

[@briannaabrianna1878]

Subscribed without skipping

[@lindahakim6936]

Thank you so much for all your wonderful help and assistance with my company's Induction & Training Program. Your assistance has been fantastic and we will certainly be calling on you again for your valuable knowledge. Best wishes, Linda Hakim, HR Manager SVC Products P/L, Australia

[@PPTVBA]

Thank you very much! I appreciate the opportunity given to me! I would love to work with you again. It was all my pleasure 😋

[@mikeburton3239]

Many thanks to you for the great tutorials you have shared. I have used your information to create a quiz. I have a problem in that whenever I use an ActiveX Control such as the CName input, in slideshow mode the box is repeated on-screen (always higher and to the left of the designed layout). It is the box which is out of line that can be clicked in to add the name etc. Are you able to help me understand what I have done wrong? I am happy to contact you directly to share a picture if that helps. Many thanks in advance, and please keep producing such great content.

[@PPTVBA]

Hello! It seems as the classic case of ActiveX appearing twice on the same screen due to "screen-sharing" or "dual-screen" set-up. The way to go about this would be to have a MsgBox that serves as an Input Box. Please send me the file over email and I can assist you further. Thank you!

[@dolorestante3054]

you have an amazing presentation. thank you very much

[@OrionKai-k6w]

please help , Im trying to save the certificate but I encountered debug

[@karininwinnipeg]

I think I found a little error in the code...? at 13:15, you say to add step 3 (to export to PDF) and grab the user name from slide 11 TBName.Value, BUT that object is earlier in the presentation, on the slide where the user enters their name.

[@PPTVBA]

Slide11 is not the same as the 11th slide in the presentation. 'Slide11' is the name of the slide-object. The naming of the slide is done in the order of the sldies created. So, if I have 10 slides already, and insert a new slide at the beginning of the presentation, its name would be Slide11 but the position of the slide would be 1, as in, the first slide of the presentation. To find the name of the slide in which your ActiveX Object (TBName) is present, just double click on the object, and you can verify which module opens up on the left pane.

[@learnfix5725]

Excellent work, many thanks for the template

[@drawandeffectsprinting7719]

Hi Bhavesh, do you have some tutorial to write codes for Failed Result slide?

[@Qalab-Ali]

Sir slide ko edit kaisy krean plz response soon

[@veliceafabianpavel1710]

20:08 ... Please tell me how do you make the timer

[@PPTVBA]

I'll be making a video on that very soon!

[@veliceafabianpavel1710]

@@PPTVBA but can you explain me a little bit sth?... I know how to make wih Vba a timer, but works in just one slide, and if I try to make a slide layout in slide master does not work.... How do you make it to work on multiple slides?

[@veliceafabianpavel1710]

I still waiting for the timer tutorial. Did you forgot?

[@omg_gamerz6328]

Hi Bhavesh when I click proceed button it shows compile error syntax error please resolve my issue

[@PPTVBA]

Hey, I believe there must be a typo in your code. Feel free to download the template from the website and cross-check the codes. If issues still persist, please send your file to my email.

[@omg_gamerz6328]

@@PPTVBA thanks now it is working but now print certificate button is not working I am sending my powerpoint project on your email

[@jennifera.4511]

I must say this's totally new to me, I couldn't imagine this kind of thing as possible with powerpoint lmao I'll do my best to learn even though I'm not the best in this area. I'm trying to create a "visual novel type of game" with ppt, please, if possible, could you explain someday how we: 1 - ask the person to write his name in slide 3, for example, and this name be used throughout the game as the characters talk with him?, 2 - create a test that defines which class the player belongs? I was watching the first ones in order to verify if it could be done with the interative quiz structure, but I'm still newbie at this. Thank you so much!

[@PPTVBA]

Heya! This sounds super exciting. We collect the input via that ActiveX TextBox, as you had seen in thei video, I used TBName.Value to refer to the name that was typed by the user. Similarly the textboxes can be populated. I can assist you better if you can just shoot me an email and we can take it from there!

[@ambergeorgeou9997]

Bhavesh, this video was excellent. I was able to put something together that fit my needs. I really enjoyed the content and I wonder if you have another similar video that includes instruction on changing a background image on your certification slide based on input from a dropdown list? For example, if in this example you gave, you made location a drop-down list and the user could select from one of 10 countries and based on the country chosen, a different image would appear on your certificate.

[@PPTVBA]

Hi Amber! This is definitely possible. We would be using an If-Then condition to confirm what flag would show up. You can use a ComboBox to make a drop-down or you can use shapes with appropriate trigger animations. On click of the particular option, you can have the macro to hide all the flags and then only show the one that is corresponding to the shape clicked. I hope this makes sense. The syntax would be: ActivePresentation.Slides(x).shapes("shapename").visible = msoFalse You'll have to make all the different shapes invisible by copypasting that line of code. And then, make the required one visible. As I'm also a freelancer, and if you'd like me to make it for you, please leave me an email. Thank you.

[@ambergeorgeou9997]

@@PPTVBA Excellent - thank you for the prompt and thorough reply. My first slide enables a trainer to enter a trainees name, course, completion date, then click on a command button to print PDF. The second slide is the certification where the name, course and date will populate. I would like to have the background of the certificate update based on the course selected so I will work with the provided syntax and see what I can do. I'm very close; thank you again for the support.

[@PPTVBA]

If it's almost completed, please feel free to send over your PowerPoint. It would be much more efficient if I record myself explaining it as this would take me only 2 minutes.

[@21CANCEL]

Hi Great, fore some reason my retry button and reset doesent work once I changed to initialize any Help

[@PPTVBA]

Have you tried downloading the template given in the description? You can match your codes to that and debug your program.

[@JenishaSweetline97]

Please upload how to do timer

[@PPTVBA]

kzbin.info/www/bejne/maC2gHqth552nac Here is how we can add a timer to our PPT Quiz Game!

[@JenishaSweetline97]

@@PPTVBA Tq so much I had seen already

[@RASHIDALI-p1d9z]

we need animation in powerpoint using vba

[@MandyAlviz]

How to show the left side part of the VBA codes window, so i can see the slides numbers? thanks

[@PPTVBA]

I use the split window option in Windows.

[@rajeshchogale6649]

Sir I was save file in ppsm and run then show me error document Window(unknown member) integer out of range. 1 is not in the valid range of 1 to0

[@PPTVBA]

Please refer to my website. I've stated how to fix that error. You have to remove the line which minimises the activewindow.

[@rajeshchogale6649]

@@PPTVBA yes sir I remove already and play correctly thanks sir

[@PPTVBA]

Great to hear!

[@divyanshjain4957]

Sir please tell which theme or template you have used No sir it is not shown which theme is used

[@PPTVBA]

Hello. This has been shown in the first part of the video. Link to that is in the description of the video.

[@hanadaabdelfattah4086]

Great tutorial 👌

[@WormLovesSinging]

Hi! Thanks for your brilliant demonstration from Hong Kong. Is there any way to display the same score across slides and in two slide formats? For instance, I have a master slide with VBA scoreboard set( format 1), and will apply it to every quiz slide, and at the end of the presentation, I would like to design another slide in format 2, with different cliparts holding the exact values from the format 1 master slide( just like your idea of making a certificate showing values from other slides). Looking forward to your kind advice. Thanks again.

[@PPTVBA]

Definitely. You can link both of them by having a separate variable which stores the required value Dim CA As Integer Sub CorrAns() CA = CA + 1 SlideLayout24.CA.Caption = CA SlideLayout12.CA.Caption = CA End Sub

[@WormLovesSinging]

@@PPTVBA Thanks for your prompt reply, yet still not quite sure how to apply these magical codes, if my score in master slide (let's say, SlideLayout15) is counted in Label1(just like what is set in kzbin.info/www/bejne/aZ_cl2Zmjdufi7s ), how to link up Label 1 value to a Shape box set on the final slide of my presentation, let's say, the CertificateSlide?

[@PPTVBA]

Certificate Slide = SlideLayout33 (assume) Score Master Slide = SlideLayout15 (assume) SlideLayout33.Label1.Caption = SlideLayout15.Label1.Caption

[@WormLovesSinging]

@@PPTVBA Thanks, you're so kind.

[@inggrida41]

You are so great. Your tutorial help my college task. Thank you

[@PPTVBA]

Glad to help! Good luck

[@marissawaldron6287]

I got an error after proceed. Item CName not found in the Shapes collection. How did I fix it?

[@PPTVBA]

Please check whether you're referring to the certificate slide properly, if there are no spelling mistakes, remember, shape names are case sensitive. Make sure the slide you're referring to has a shape named *CName* within it. C and N as capital letters.

[@pravinsatbhai2412]

Hi Bhavesh, I have made the quize game as per your video, but my ppt is give the error for the If condition for the percentage above 50. When there is score of less that 50 % , it is giving the msg as set into the VBA; but when there is score of above 50 it is showing the erro for the if condition. Please guide..

[@PPTVBA]

There might be some syntax error due to typos. Remember that VBA is case sensitive. You can check my sample file and codes which are provided in my website.

[@pravinsatbhai2412]

Hi Bhavesh,Good morning. I want to add the external printer to the VBA for same ppt, can you please guide for the same..

[@PPTVBA]

Use ActivePresentation.PrintOut function. You can find more on the official Microsoft Documentation.

[@thepingvinimking1715]

Hey :) I have a question, I was using a font in my presentation that I was sending to someone, but they don’t have the font on their computer. How do I make the font show up in their computer too?

[@PPTVBA]

Go to ppt settings > save > embed fonts Edit: ppt *options*

[@thepingvinimking1715]

Bhavesh Shaha Ho woowwwww thank youuuu And how when revisiting a slide where an animation had played, it will replay?

[@PPTVBA]

Ah yes. You will have to use VBA for that. We need to reset the slide and the animation timeline when they revisit the slide.

[@thepingvinimking1715]

Bhavesh Shaha Ok... and where is the ppt settings? I don’t find them lol

[@PPTVBA]

Which version of ppt are you using?

[@patricianereim5576]

I successfully went through all the three tutorials, and it works great. However, when I save it as a show. ppsm, it will work on my computer, but when I sent it to another computer, the program opens, but does not work. I would like to use this without anyone seeing the slides on the sidebar. I did remove the one statement that stated to remove from the code if using .ppsm, but this still did not work.

[@PPTVBA]

Macro settings need to be enabled in the computer to allow for .ppsm files to run. Go to developer > macro settings > enable

[@oluwolejames2388]

Hi Bhavesh Shaha! please how Can I add total time spent to a quiz presentation and how can i also convert my quiz presentation in PowerPoint to executable file?

[@PPTVBA]

I'm still working on the time spent feature. I got a prototype but it also calculates the time wasted in reading the message box... You can save it as a .ppsm file if you want it to open directly, I will research on the .exe feature. Thank you.

[@rajeshchogale6649]

Thanks sir I create quiz game. Thanks again and again and again

[@PPTVBA]

Dhanyavad! Thank you!

[@rajeshchogale6649]

Sir I am primary teacher and I used in my classroom. Thanks sir

[@rajeshchogale6649]

@@PPTVBA sir I add timer in this presentation (quiz)

[@PPTVBA]

@@rajeshchogale6649 I will be making a tutorial on adding a timer by this week!

[@PPTVBA]

kzbin.info/www/bejne/maC2gHqth552nac This is how we add a timer in our PPT Quiz Game.

[@briannaabrianna1878]

Thank you for sharing your talents

[@inggrida41]

Why does my proceed button can't work? Help me please

[@PPTVBA]

That's odd. Have you tried downloading the template from the description below?

[@inggrida41]

@@PPTVBA because my word still 2016 not 2019 so it can't

[@PPTVBA]

@@inggrida41 this game can work on PowerPoint 2007 onwards. Try downloading the template, enable macros and play it.

[@pravinsatbhai2412]

Helo Bhavesh, Thanks for the video. Van you please suggest how can we maintain the record of it or how can we save these details to excel

[@PPTVBA]

I have already uloaded a video on this topic! Please check my channel. It is part 6 of how to make a quiz game in PowerPoint.

[@Selva11091974]

Hi Bhavesh, Your presentation is excellent and the steps were easy to follow. I do have a query. How to ensure the program works properly in dual monitors? Sometimes the text box to enter the name is appearing twice in my system and i believe it is a dual monitor issue. Appreciate if you can let me know how to fix it. Thanks in advance and keep up the good work.

[@PPTVBA]

I am sorry, I have never got the opportunity to work with a dual set up. I did find one article for excel: www.thespreadsheetguru.com/the-code-vault/launch-vba-userforms-in-correct-window-with-dual-monitors, maybe something similar could be used for PPT?

[@nuviaaguilar3379]

Hi. Thank you for such a nice support! I want to save slides 1 to 10 and also 12 but not 11. What code do I need in such case? Appreciate your help in advance.

[@PPTVBA]

A very good question! I regret not mentioning this in the video. I have updated my webpage with the exact code which you'll need. The link of the webpage is in the description (the one where you can download the code from). pptvba.com/ppt-quiz-certificate/

[@nuviaaguilar3379]

@@PPTVBA Thank you! You're so kind by helping us all. I have seen your so helpful blog already just as you ask me to do. Please See what I have and still does not work. Sub CommandButton2_Click() 'save Data '1. Choosing the location: Application.FileDialog(msoFileDialogFolderPicker).Show Dim Location As String Location = Application.FileDialog(msoFileDialogFolderPicker).SelectedItems(1) & "\" '2. Declaring the slides which are to be printed ActivePresentation.Slides.Range(Array(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 12)).Select '3. Exporting it as a .pdf file ActivePresentation.ExportAsFixedFormat _ Path:=Location & "Interactive literacy quiz" & ".PDF", _ FixedFormatType:=ppFixedFormatTypePDF, _ RangeType:=ppPrintSelection End Sub There is one only thing I am not adding "Slide11.TBName.Value" which I consider unnecesary. I wonder if I must add something in replacement or there is something else wrong. Message box that stops processing "Slide(unknown memeber): invalid request. This view does not support selection." Sorry to bother you! Appreciate your help.

[@PPTVBA]

Are you saving the file in the .PPSM format?

[@nuviaaguilar3379]

@@PPTVBA Yes!

[@PPTVBA]

@@nuviaaguilar3379 ah that could be the issues, no worries, I'll look into it and update my blog post.

[@ggg1954]

Bhavesh. Thank you for the details on how to make a certificate. I have almost got it. I have had difficulty in finding how to reset the slide so that the name is blank (I only want the name). Your presentation goes to a Slidelayout24 but I do not have any slide layout in that frame. Have I missed something? Additionally I want to run it as a Powerpoint Show when it is opened which works but after printing I get an error message 'Run-time error '-2147188160 (80048240): DocumentWindows (unknown member) : Inter out of range , 1 is not in the valid range of 1 to 0'. Can you help me please?

[@PPTVBA]

SlideLayout24 is unique to my presentation. It could possibly be with the different name. Did you follow part 1 and part 2 of the tutorial before watching this? We created SlideLayout24 in the first part of this tutorial series. Regarding the .ppsm format, you'll need to remove the line of code where the window is minimised. I've written about this error in my website. Please let me know if the errors are solved! You can also email me the file so that I can take a look at it.

[@ggg1954]

Bhavesh Shaha thanks Bhavesh. I will review 1 and 2. I appreciate your quick response.

[@PPTVBA]

Glad to help you out! My website also has lots of free resources as well as paid resources if you're interested! There are lots of more features in ppt quizzes, it's all in my channel!

[@namratakulkarni1967]

I tried your quiz game but in my PC message came that Define CertificateSlide please help me what should i do?

[@PPTVBA]

Your coding seems to have an error. Check whether the spelling of your SubRoutines are correct.

[@namratakulkarni1967]

@@PPTVBA , presentation is not taking Private Sub Commanduttone ()

[@PPTVBA]

@@namratakulkarni1967 I apologise. I am not able to understand your message. Can you please download my template (link in the description) and check if that's working?

[@pinoymatinik3882]

Good day sir., I really adored your tutorial so much.. but i do the coding following your tutorials I really find hard debugging the code in part 3 : EXPORTING IT AS PDF. because there is an error sir. and also the other video tutorial about the RANDOMIZED SELECTION it works but the i check the selection some sections are missing T.T

[@PPTVBA]

Heya, please share the error with me. It would be hard to debug without having the file with me, so I'd appreciate it if you could send that over to me via email.

[@bhattnirav322]

Hii bhavesh can we send email as soon as we click on ok after pdf has been generated. I want that as soon as learner click on pdf has been generated his certificate shall be come on my mail immediately.

[@PPTVBA]

You can use outlook to send mails via vba - you can look up the codes!

[@bhattnirav322]

@@PPTVBA Thanks for reply bhavesh, I tried but i couldnt find codes. Can u pls make a video on that or send me code. Pls. I will be very thankful to you.

[@PPTVBA]

This could take some time. However, if you're willing to hire me - I could make one personally and send it to you.

[@railwayjade]

Hi Bhavesh - thank you for this great series! Can you show us how to code that the command button is disabled unless name and location fields are filled in with info before proceeding. Once name and location are filled in with at least one letter, then the proceed button is enabled and one can continue the game.

[@PPTVBA]

Yes, we can do that by adding an If-Then function. If TBName.Value = "" Then MsgBox "Enter a Name" End If.

[@mausergrenaderifle9980]

Good Evening Sir, May i seek permission to use these macros to my PowerPoint Presentation? Thanks for any reply.

[@PPTVBA]

Yes definitely. Feel free to use it.

[@sherisnyder8607]

This is a great tool and I thank you for all your hard work! The tutorials are great too! I am having one issue. Everything seems to work but when I click on "print certificate" nothing seems to happen. I have checked the code but perhaps you can give me a clue as to what might be the issue. THanks again!!

[@PPTVBA]

Can you please send the file over to me? I can have a look at the coding and debug it! Also my free templates are available on my website, you can download and check whether the Print option works in that and replicate the same.

[@sherisnyder8607]

@@PPTVBA I'm not sure if my reply posted as I do not see it. Thank you so much and yes I would like to send you the file. What is your e-mail please?

[@PPTVBA]

It is mentioned in my video description.

[@ianroper1029]

Bhavesh, thanks for a fantastic tutorial that I have used to prepare a course for my work colleagues. It works perfectly when saved as a pptm. However when I save it as a ppsm (so that they have to follow the slides without being able to cheat!) I get a run time error box appearing after selecting the folder to save the certificate into (though the certificate does save). The error message is: Run Time Error '-2147188160(80048240)': DocumentWindows (Unknown member) : Integer out of range. 1 is not in the range of 1 to 0. When I click on debug abd teh visual basic code window appears, the following line under number 4 is highlighted in yellow ActivePresentation.Windows(1).WindowState = ppWindowMinimized Any thoughts on how to fix this? - I believe it is something to do with running this as a show rather than presentation as it works perfectly when run as a presentation file.

[@PPTVBA]

Please remove the line "ActivePresentation.Windows(1).WindowState = ppWindowMinimized" when you are saving it as .PPSM! That should do the trick!

[@ianroper1029]

@@PPTVBA That did it, thanks very such for such a prompt reply.

[@PPTVBA]

@@ianroper1029 Glad to help! I also do freelancing for vba if you're interested!

[@ianroper1029]

Bhavesh Shaha Thanks for the offer but I developed the course because of Covid19 and it was a one off. I had already done the bulk of the content, but your videos absolutely transformed it into a professional looking course with quiz and certificate. Your videos as I said before were excellent and very easy to follow (and I’m a 53 year who is ok with computers but has never tried following the Visual Basic stuff!). Thanks again

[@PPTVBA]

Glad to help you sir! Please do suggest more tutorials for features which you'd like to see implemented in this quiz game series! I'm planning to make one where the results can go to an excel sheet.

[@beverlypanganibancadacio9472]

Super amazing! But can I add more questions. How po?

[@PPTVBA]

You can duplicate the question slides and edit the codes accordingly.

[@ammarmuhammadmansuramanmaz1870]

Hi superb , unfortunately I am not able to save the location for printing and this is the message I am getting ActivePresentation.ExportAsFixedFormat Location & Slide30.TBName.Value & " Theory Exam Certificate" & ".PDF", ppFixedFormatTypePDF, , , , , , SlidesToBePrinted, ppPrintSlideRange

[@PPTVBA]

Can you please check if TBName is actually in Slide30. Remember that 30 isn't the slide number but the name of the slide. Double click the TBName ActiveX Element to find out the slide name in which it is present.

[@dharmendrasankhla55]

👍😇

[@Tenzinforeal]

Yar bhai oh you don't know hindi na 😝. So i want to tell you if you make gameplay videos your channel will grow better so do it right now now now and now please

[@PPTVBA]

Mujhe hindi aata he re, gameplay me itna interested nahi hoon.

[@Tenzinforeal]

Oh cool

[@Tenzinforeal]

When is your new video coming

[@PPTVBA]

@@Tenzinforeal I have another channel called "Basically Bhavesh".

[@seaweishen3708]

Hi after adding the Slide11.TbName code, the start game button doesn't seem to work anymore. I've sent my PowerPoint to your email, thanks for the helpful tutorial.

[@PPTVBA]

5:58, in my presentation I got Slide11. However, the '11' can be different for you. You can double-click and figure out what SlideXX your TbName is present. I checked your file, it is Slide58.