This is fantastic Bhavesh, I need to watch all your presentations. Could you add a print results to the final slide that would give the student name, date and score. Thanks again.
I have a premium template which sends all the attempted answers of the students in an excel sheet along with the time taken per question. It has a lots of features if you're interested in purchasing it. It is in my website. You can create something which prints student name, date and score using a similar method as I've shown in *ppt quiz game with certificate* tutorial. It is my channel. Thank you!
Hi Bhavesh, i really LOVE your videos. you have often saved me from despair ;-). Thank you. One question: Is it possiblie to activate the textboxes by using the tab-key? I deal a lot with digital accessibility. this function would be great for that. Thanks in advance :)
@@PPTVBA ThankYou I tryed ComboBox yesterday. It even works great. But there is one thing i can´t fix on my own. If i select text longer than box the text isn´t shown fully. So maybe you can help with vba about WordWrap? Looking forward on your answer. Have a nice week.
@@PPTVBA oh no sorry i can´t there are informations from work in it- i use to create presentations i need for work while i am learning coding in private time. It is an developer- Combobox with vba called .additem. For ixample .additem "Assessment"- i want the Box to stay in witdh and lengh- so the word Assessment ends on (Assess-) now i want the combobox do automatically wrap the text.
@@katjaw9957 not an issue! Was there any option for word wrap in the properties of the activex menu? I haven't worked with this item much so I do have the experience. Is there any chance you can hard code the link breaks by typing & vbNewLine &
Thank you very much for such great content! You’re awesome! And also I have a question for you: is it possible to add to this presentation a slide, where a person can read the task and to write his voice as an answer? I understand that such question couldn’t be count as correct or wrong, but still. For example, I need children to describe a picture and I need them talk, so I need to write their voice. Thanks a lot for your job!
"write his voice as an answer" You want the child to speak and the PowerPoint to record their voice? You can make the kid go to Slide Show - Record Slide Show and then they can navigate through the slides and speak. The webcam and the microphone will record the kid and it will be placed in the corner of the slide. You can review the presentation in slide-show mode which will now contain the kid's audio too.
I mean “to record” the pupil’s voice as an answer. I’m from Russia and we have such an exam which is called “ОГЭ” (for 9th form or grade or class students), “ЕГЭ”(for 11th form or grade or class students) or “ВПР” (for 7th form or grade or class students). For example, in “ВПР” we have 6 tasks: 1) listen the record and choose correct answer (there are 5 statements in this task and three variants to answer in each of them), 2) read the small text aloud (the computer record the voice of the child when he is reading the text), 3) describe a picture (pupils use a plan which have 5 parts and make a report about the picture that they see on the screen; the computer also record the pupil’s answer). And so on. I asked about this second and third tasks. Is it possible to create a task with a button, which will be pressed by student and record as an audio file. This record will be listened by teacher and then teacher can add points for this task to the whole mark. And in excel table there could be a tick or a plus if a child have done this task and minus or something else if he hasn’t done this task. Is it possible to create such button on a slide that will turn on the voice record, will be recording only 90 seconds and then will go to the next slide with another task. (I know that PowerPoint has a button of voice recording but pupils won’t record this task separate from the whole test. I need to do such slide where they can press the button, talk only 90 seconds, record their voice and go to another task). Thank you very much for doing such videos for us! Your videos are very useful for teachers! )))
you are brilliant in every ppt u do... pls help me on how i could make the score of the student in the ppt be recorded in excel... and similarly how can my ppt automatically run when the student open it?
I have a premium template for this which saves the answers in excel which you can purchase from my website - it can open directly and start running when the student opens it too!
How to make only one slide with various fill in the blanks questions 😭😭help me please, how to do with ‘ for i 1-6’ bcause I only have 1slide for the question
You're watching part 3 of the video series on the PowerPoint Fill In The Blanks. As mentioned in the beginning, I've shown how the game has been created from scratch in a different video. I've also added the same video card at 00:04 (top right). I hope this clarifies things! Thank you for commenting. Here's part 1: ua-cam.com/video/OIpqD8TWSMw/v-deo.html
![How to create FILL IN THE BLANKs in PowerPoint - Interactive Game [PPT VBA Tutorial]](http://i.ytimg.com/vi/OIpqD8TWSMw/mqdefault.jpg)
![How to create FILL IN THE BLANKs in PowerPoint - Interactive Game [PPT VBA Tutorial]](/img/tr.png)
yeah my Man...you're skill in VBA is commendable..my salute to you Sir..
Thank you very much! It's just creative out-of-the-box thinking with the simplest of codes.
You are going places!
Thank you!
ANOTHER GREAT VID!! THANKS!
Thank you very much! Was the tutorial understandable? I had to re-do this.
Wow.... It's great I will try this on weekend. Thank you very much I can learn a lot while watching your videos
Yay! Glad to help you out. My best wishes for a productive weekend!
This is fantastic Bhavesh, I need to watch all your presentations. Could you add a print results to the final slide that would give the student name, date and score. Thanks again.
I have a premium template which sends all the attempted answers of the students in an excel sheet along with the time taken per question. It has a lots of features if you're interested in purchasing it. It is in my website.
You can create something which prints student name, date and score using a similar method as I've shown in *ppt quiz game with certificate* tutorial. It is my channel.
Thank you!
Hi Bhavesh, i really LOVE your videos. you have often saved me from despair ;-). Thank you. One question: Is it possiblie to activate the textboxes by using the tab-key? I deal a lot with digital accessibility. this function would be great for that. Thanks in advance :)
Jeah- got time to create it this weekend and your code works greate- next weekend i will try to insert questions with drop down answers.
That's wonderful! Have a great weekend with PowerPoint and VBA!
@@PPTVBA ThankYou I tryed ComboBox yesterday. It even works great. But there is one thing i can´t fix on my own. If i select text longer than box the text isn´t shown fully. So maybe you can help with vba about WordWrap? Looking forward on your answer. Have a nice week.
@@katjaw9957 can you send the pptm to my email?
@@PPTVBA oh no sorry i can´t there are informations from work in it- i use to create presentations i need for work while i am learning coding in private time. It is an developer- Combobox with vba called .additem. For ixample .additem "Assessment"- i want the Box to stay in witdh and lengh- so the word Assessment ends on (Assess-) now i want the combobox do automatically wrap the text.
@@katjaw9957 not an issue! Was there any option for word wrap in the properties of the activex menu?
I haven't worked with this item much so I do have the experience. Is there any chance you can hard code the link breaks by typing & vbNewLine &
Thank you very much for such great content! You’re awesome! And also I have a question for you: is it possible to add to this presentation a slide, where a person can read the task and to write his voice as an answer? I understand that such question couldn’t be count as correct or wrong, but still. For example, I need children to describe a picture and I need them talk, so I need to write their voice.
Thanks a lot for your job!
"write his voice as an answer"
You want the child to speak and the PowerPoint to record their voice?
You can make the kid go to Slide Show - Record Slide Show and then they can navigate through the slides and speak.
The webcam and the microphone will record the kid and it will be placed in the corner of the slide. You can review the presentation in slide-show mode which will now contain the kid's audio too.
I mean “to record” the pupil’s voice as an answer. I’m from Russia and we have such an exam which is called “ОГЭ” (for 9th form or grade or class students), “ЕГЭ”(for 11th form or grade or class students) or “ВПР” (for 7th form or grade or class students). For example, in “ВПР” we have 6 tasks: 1) listen the record and choose correct answer (there are 5 statements in this task and three variants to answer in each of them), 2) read the small text aloud (the computer record the voice of the child when he is reading the text), 3) describe a picture (pupils use a plan which have 5 parts and make a report about the picture that they see on the screen; the computer also record the pupil’s answer). And so on. I asked about this second and third tasks. Is it possible to create a task with a button, which will be pressed by student and record as an audio file. This record will be listened by teacher and then teacher can add points for this task to the whole mark. And in excel table there could be a tick or a plus if a child have done this task and minus or something else if he hasn’t done this task. Is it possible to create such button on a slide that will turn on the voice record, will be recording only 90 seconds and then will go to the next slide with another task. (I know that PowerPoint has a button of voice recording but pupils won’t record this task separate from the whole test. I need to do such slide where they can press the button, talk only 90 seconds, record their voice and go to another task).
Thank you very much for doing such videos for us! Your videos are very useful for teachers! )))
@@irinapolyakova4182 can you please send me a mail with the same?
Ok
Bhavesh Sir. i really love your tutorials, is it possible to have virtual training with you please?
Some of the videos blank out during the coding sessions, I won't mind a virtual session
Please how do I contact you for this Sir?
You cant send me a message via my website!
Thank you for your prompt reply. Your tutorial is really fantastic. Today I received your email. Thank you very much.
Glad that the fill in the blanks module helped you out! Have a great day!
Thank you for your help
you are brilliant in every ppt u do... pls help me on how i could make the score of the student in the ppt be recorded in excel... and similarly how can my ppt automatically run when the student open it?
I have a premium template for this which saves the answers in excel which you can purchase from my website - it can open directly and start running when the student opens it too!
what if only 1 slide for 5 question... what is the formula?
So nice. The coding are difficult to visualize. Can you please give a link to copy the code
The link is the description! pptvba.com/fill-in-the-blanks/
Can we control animation in PowerPoint by PowerPoint vba?
thanks
Yes we can! But it becomes a bit tedious like that. I prefer to use trigger animations mostly.
@@PPTVBA thank you
How to make only one slide with various fill in the blanks questions 😭😭help me please, how to do with ‘ for i 1-6’ bcause I only have 1slide for the question
If you have only one slide: for i = 1 to 1.
@@PPTVBA thankyou so much, ure very genius
You go too fast for a beginner to understand and follow. Please make a powerpoint presentation from scratch.
You're watching part 3 of the video series on the PowerPoint Fill In The Blanks. As mentioned in the beginning, I've shown how the game has been created from scratch in a different video. I've also added the same video card at 00:04 (top right). I hope this clarifies things! Thank you for commenting.
Here's part 1:
ua-cam.com/video/OIpqD8TWSMw/v-deo.html