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

  Рет қаралды 15,363

Bhavesh Shaha - PowerPoint Games

Bhavesh Shaha - PowerPoint Games

Күн бұрын

Download code and file: pptvba.com/ppt-quiz-certificate/
Adding TIMER in PPT Quiz: • How to add TIME-LIMIT ...
#PowerPoint #VBA #PPTVBA
================
Timestamps: (damn it became 20 minutes)
1. Introduction: 00:00
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 % greater 50%: 17:04
9. Clearing the input textbox: 17:56
10. Testing the game: 19:28
In this Microsoft PowerPoint Tutorial, we will be using Visual Basic Coding (VBA Coding) and making an interactive quiz game which can be used by teachers and in online courses.
We will be making a certificate slide which would contain the name, location of the student. We will be asking them to input those details in the beginning slide.
We will then add a VBA Macro code which would allow us to print the certificate slide which contains the input values (Name and location) of the student, and the Result Slide as .PDF file. The user can choose the location of the file. We get to choose the name of the file.
==========================================
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.
==========================================
CODE:
You can get the full code from the .pptm file which can be downloaded from my website.
I am unable to type in the description because KZbin says that I have angle brackets in my code.
==========================================
Music: Lakey Inspired - Distant
/ lakeyinspired
Bhavesh Shaha,
2002bhavesh@gmail.com
/ bhaveshshaha
basicallybhavesh (DMs are open)

Пікірлер: 137
@azizmamat
@azizmamat 5 жыл бұрын
Alhamdulillah, terbaik. Saya dari Malaysia, Sir Bhavesh.
@gansee3782
@gansee3782 Жыл бұрын
Thanks for sharing and providing such a clear and good guidance in creating games.
@gansee3782
@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.
@dolorestante3054
@dolorestante3054 2 жыл бұрын
you have an amazing presentation. thank you very much
@learnfix5725
@learnfix5725 Жыл бұрын
Excellent work, many thanks for the template
@lindahakim6936
@lindahakim6936 4 жыл бұрын
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
@PPTVBA 4 жыл бұрын
Thank you very much! I appreciate the opportunity given to me! I would love to work with you again. It was all my pleasure 😋
@briannaabrianna1878
@briannaabrianna1878 4 жыл бұрын
Subscribed without skipping
@briannaabrianna1878
@briannaabrianna1878 4 жыл бұрын
Thank you for sharing your talents
@inggrida41
@inggrida41 5 жыл бұрын
You are so great. Your tutorial help my college task. Thank you
@PPTVBA
@PPTVBA 5 жыл бұрын
Glad to help! Good luck
@hanadaabdelfattah4086
@hanadaabdelfattah4086 4 жыл бұрын
Great tutorial 👌
@PPTVBA
@PPTVBA 5 жыл бұрын
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
@nuviaaguilar3379 4 жыл бұрын
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.
@ambergeorgeou9997
@ambergeorgeou9997 3 жыл бұрын
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
@PPTVBA 3 жыл бұрын
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
@ambergeorgeou9997 3 жыл бұрын
@@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
@PPTVBA 3 жыл бұрын
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.
@jennifera.4511
@jennifera.4511 3 жыл бұрын
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
@PPTVBA 3 жыл бұрын
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!
@mikeburton3239
@mikeburton3239 3 жыл бұрын
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
@PPTVBA 3 жыл бұрын
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!
@drawandeffectsprinting7719
@drawandeffectsprinting7719 3 жыл бұрын
Hi Bhavesh, do you have some tutorial to write codes for Failed Result slide?
@Selva11091974
@Selva11091974 4 жыл бұрын
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
@PPTVBA 4 жыл бұрын
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?
@WormLovesSinging
@WormLovesSinging 4 жыл бұрын
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
@PPTVBA 4 жыл бұрын
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
@WormLovesSinging 4 жыл бұрын
@@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
@PPTVBA 4 жыл бұрын
Certificate Slide = SlideLayout33 (assume) Score Master Slide = SlideLayout15 (assume) SlideLayout33.Label1.Caption = SlideLayout15.Label1.Caption
@WormLovesSinging
@WormLovesSinging 4 жыл бұрын
@@PPTVBA Thanks, you're so kind.
@rajeshchogale6649
@rajeshchogale6649 4 жыл бұрын
Thanks sir I create quiz game. Thanks again and again and again
@PPTVBA
@PPTVBA 4 жыл бұрын
Dhanyavad! Thank you!
@rajeshchogale6649
@rajeshchogale6649 4 жыл бұрын
Sir I am primary teacher and I used in my classroom. Thanks sir
@rajeshchogale6649
@rajeshchogale6649 4 жыл бұрын
@@PPTVBA sir I add timer in this presentation (quiz)
@PPTVBA
@PPTVBA 4 жыл бұрын
@@rajeshchogale6649 I will be making a tutorial on adding a timer by this week!
@PPTVBA
@PPTVBA 4 жыл бұрын
kzbin.info/www/bejne/maC2gHqth552nac This is how we add a timer in our PPT Quiz Game.
@oluwolejames2388
@oluwolejames2388 5 жыл бұрын
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
@PPTVBA 5 жыл бұрын
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.
@user-we1us9hy6k
@user-we1us9hy6k Жыл бұрын
we need animation in powerpoint using vba
@sherisnyder8607
@sherisnyder8607 3 жыл бұрын
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
@PPTVBA 3 жыл бұрын
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
@sherisnyder8607 3 жыл бұрын
@@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
@PPTVBA 3 жыл бұрын
It is mentioned in my video description.
@21CANCEL
@21CANCEL 4 жыл бұрын
Hi Great, fore some reason my retry button and reset doesent work once I changed to initialize any Help
@PPTVBA
@PPTVBA 4 жыл бұрын
Have you tried downloading the template given in the description? You can match your codes to that and debug your program.
@dharmendrasankhla55
@dharmendrasankhla55 Жыл бұрын
👍😇
@pravinsatbhai2412
@pravinsatbhai2412 4 жыл бұрын
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
@PPTVBA 4 жыл бұрын
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.
@MandyAlviz
@MandyAlviz Жыл бұрын
How to show the left side part of the VBA codes window, so i can see the slides numbers? thanks
@PPTVBA
@PPTVBA Жыл бұрын
I use the split window option in Windows.
@Qalab-Ali
@Qalab-Ali 3 жыл бұрын
Sir slide ko edit kaisy krean plz response soon
@thepingvinimking1715
@thepingvinimking1715 5 жыл бұрын
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
@PPTVBA 5 жыл бұрын
Go to ppt settings > save > embed fonts Edit: ppt *options*
@thepingvinimking1715
@thepingvinimking1715 5 жыл бұрын
Bhavesh Shaha Ho woowwwww thank youuuu And how when revisiting a slide where an animation had played, it will replay?
@PPTVBA
@PPTVBA 5 жыл бұрын
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
@thepingvinimking1715 5 жыл бұрын
Bhavesh Shaha Ok... and where is the ppt settings? I don’t find them lol
@PPTVBA
@PPTVBA 5 жыл бұрын
Which version of ppt are you using?
@pinoymatinik3882
@pinoymatinik3882 2 жыл бұрын
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
@PPTVBA 2 жыл бұрын
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.
@beverlypanganibancadacio9472
@beverlypanganibancadacio9472 4 жыл бұрын
Super amazing! But can I add more questions. How po?
@PPTVBA
@PPTVBA 4 жыл бұрын
You can duplicate the question slides and edit the codes accordingly.
@railwayjade
@railwayjade 5 жыл бұрын
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
@PPTVBA 4 жыл бұрын
Yes, we can do that by adding an If-Then function. If TBName.Value = "" Then MsgBox "Enter a Name" End If.
@karininwinnipeg
@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
@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.
@patricianereim5576
@patricianereim5576 4 жыл бұрын
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
@PPTVBA 4 жыл бұрын
Macro settings need to be enabled in the computer to allow for .ppsm files to run. Go to developer > macro settings > enable
@divyanshjain4957
@divyanshjain4957 3 жыл бұрын
Sir please tell which theme or template you have used No sir it is not shown which theme is used
@PPTVBA
@PPTVBA 3 жыл бұрын
Hello. This has been shown in the first part of the video. Link to that is in the description of the video.
@omg_gamerz6328
@omg_gamerz6328 2 жыл бұрын
Hi Bhavesh when I click proceed button it shows compile error syntax error please resolve my issue
@PPTVBA
@PPTVBA 2 жыл бұрын
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
@omg_gamerz6328 2 жыл бұрын
@@PPTVBA thanks now it is working but now print certificate button is not working I am sending my powerpoint project on your email
@marissawaldron6287
@marissawaldron6287 4 жыл бұрын
I got an error after proceed. Item CName not found in the Shapes collection. How did I fix it?
@PPTVBA
@PPTVBA 4 жыл бұрын
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.
@rajeshchogale6649
@rajeshchogale6649 4 жыл бұрын
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
@PPTVBA 4 жыл бұрын
Please refer to my website. I've stated how to fix that error. You have to remove the line which minimises the activewindow.
@rajeshchogale6649
@rajeshchogale6649 4 жыл бұрын
@@PPTVBA yes sir I remove already and play correctly thanks sir
@PPTVBA
@PPTVBA 4 жыл бұрын
Great to hear!
@pravinsatbhai2412
@pravinsatbhai2412 4 жыл бұрын
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
@PPTVBA 4 жыл бұрын
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
@pravinsatbhai2412 4 жыл бұрын
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
@PPTVBA 4 жыл бұрын
Use ActivePresentation.PrintOut function. You can find more on the official Microsoft Documentation.
@mausergrenaderifle9980
@mausergrenaderifle9980 4 жыл бұрын
Good Evening Sir, May i seek permission to use these macros to my PowerPoint Presentation? Thanks for any reply.
@PPTVBA
@PPTVBA 4 жыл бұрын
Yes definitely. Feel free to use it.
@nuviaaguilar3379
@nuviaaguilar3379 4 жыл бұрын
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
@PPTVBA 4 жыл бұрын
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
@nuviaaguilar3379 4 жыл бұрын
@@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
@PPTVBA 4 жыл бұрын
Are you saving the file in the .PPSM format?
@nuviaaguilar3379
@nuviaaguilar3379 4 жыл бұрын
@@PPTVBA Yes!
@PPTVBA
@PPTVBA 4 жыл бұрын
@@nuviaaguilar3379 ah that could be the issues, no worries, I'll look into it and update my blog post.
@JenishaSweetline97
@JenishaSweetline97 4 жыл бұрын
Please upload how to do timer
@PPTVBA
@PPTVBA 4 жыл бұрын
kzbin.info/www/bejne/maC2gHqth552nac Here is how we can add a timer to our PPT Quiz Game!
@JenishaSweetline97
@JenishaSweetline97 4 жыл бұрын
@@PPTVBA Tq so much I had seen already
@veliceafabianpavel1710
@veliceafabianpavel1710 5 жыл бұрын
20:08 ... Please tell me how do you make the timer
@PPTVBA
@PPTVBA 5 жыл бұрын
I'll be making a video on that very soon!
@veliceafabianpavel1710
@veliceafabianpavel1710 5 жыл бұрын
@@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
@veliceafabianpavel1710 4 жыл бұрын
I still waiting for the timer tutorial. Did you forgot?
@ianroper1029
@ianroper1029 4 жыл бұрын
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
@PPTVBA 4 жыл бұрын
Please remove the line "ActivePresentation.Windows(1).WindowState = ppWindowMinimized" when you are saving it as .PPSM! That should do the trick!
@ianroper1029
@ianroper1029 4 жыл бұрын
@@PPTVBA That did it, thanks very such for such a prompt reply.
@PPTVBA
@PPTVBA 4 жыл бұрын
@@ianroper1029 Glad to help! I also do freelancing for vba if you're interested!
@ianroper1029
@ianroper1029 4 жыл бұрын
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
@PPTVBA 4 жыл бұрын
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.
@bhattnirav322
@bhattnirav322 4 жыл бұрын
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
@PPTVBA 4 жыл бұрын
You can use outlook to send mails via vba - you can look up the codes!
@bhattnirav322
@bhattnirav322 4 жыл бұрын
@@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
@PPTVBA 4 жыл бұрын
This could take some time. However, if you're willing to hire me - I could make one personally and send it to you.
@namratakulkarni1967
@namratakulkarni1967 5 жыл бұрын
I tried your quiz game but in my PC message came that Define CertificateSlide please help me what should i do?
@PPTVBA
@PPTVBA 5 жыл бұрын
Your coding seems to have an error. Check whether the spelling of your SubRoutines are correct.
@namratakulkarni1967
@namratakulkarni1967 5 жыл бұрын
@@PPTVBA , presentation is not taking Private Sub Commanduttone ()
@PPTVBA
@PPTVBA 5 жыл бұрын
@@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?
@ggg1954
@ggg1954 4 жыл бұрын
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
@PPTVBA 4 жыл бұрын
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
@ggg1954 4 жыл бұрын
Bhavesh Shaha thanks Bhavesh. I will review 1 and 2. I appreciate your quick response.
@PPTVBA
@PPTVBA 4 жыл бұрын
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!
@inggrida41
@inggrida41 5 жыл бұрын
Why does my proceed button can't work? Help me please
@PPTVBA
@PPTVBA 4 жыл бұрын
That's odd. Have you tried downloading the template from the description below?
@inggrida41
@inggrida41 4 жыл бұрын
@@PPTVBA because my word still 2016 not 2019 so it can't
@PPTVBA
@PPTVBA 4 жыл бұрын
@@inggrida41 this game can work on PowerPoint 2007 onwards. Try downloading the template, enable macros and play it.
@ammarmuhammadmansuramanmaz1870
@ammarmuhammadmansuramanmaz1870 4 жыл бұрын
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
@PPTVBA 4 жыл бұрын
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.
@Tenzinforeal
@Tenzinforeal 4 жыл бұрын
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
@PPTVBA 4 жыл бұрын
Mujhe hindi aata he re, gameplay me itna interested nahi hoon.
@Tenzinforeal
@Tenzinforeal 4 жыл бұрын
Oh cool
@Tenzinforeal
@Tenzinforeal 4 жыл бұрын
When is your new video coming
@PPTVBA
@PPTVBA 4 жыл бұрын
@@Tenzinforeal I have another channel called "Basically Bhavesh".
@seaweishen3708
@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
@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.
How to add TIME-LIMIT (timer) PowerPoint Quiz Game [PPT VBA Tutorial]
6:49
Bhavesh Shaha - PowerPoint Games
Рет қаралды 43 М.
PowerPoint Quiz Game - Multiple Correct Answers | PPT VBA Tutorial
18:55
Bhavesh Shaha - PowerPoint Games
Рет қаралды 7 М.
Pleased the disabled person! #shorts
00:43
Dimon Markov
Рет қаралды 29 МЛН
Iron Chin ✅ Isaih made this look too easy
00:13
Power Slap
Рет қаралды 36 МЛН
Can A Seed Grow In Your Nose? 🤔
00:33
Zack D. Films
Рет қаралды 21 МЛН
3 Cool Effects You Did NOT Think are Possible in PowerPoint | Morph
11:17
Make PPT Quiz Game Report Card - percentages, no. of correct answers | PPT VBA Macro Tutorial
9:01
15   Macro in PowerPoint |Microsoft PowerPoint |
17:53
Skill Courses Academy
Рет қаралды 1 М.
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 452 М.
Deal or No Deal -- On a spreadsheet
8:28
MountainHawkPYL
Рет қаралды 544
How to save PPT Quiz Results to Excel Sheet with Question & Attempted Answer [VBA Tutorial]
12:17
How to create Fill in the Blanks with Points & Time limit in PowerPoint Tutorial
11:56
Bhavesh Shaha - PowerPoint Games
Рет қаралды 7 М.
Pleased the disabled person! #shorts
00:43
Dimon Markov
Рет қаралды 29 МЛН