Create Multiple Fill in the Blanks Interactive PowerPoint Presentation [PPT VBA Tutorial]

Поделиться
HTML-код
  • Опубликовано: 27 янв 2025

Комментарии • 43

  • @glennapoles1292
    @glennapoles1292 4 года назад +1

    yeah my Man...you're skill in VBA is commendable..my salute to you Sir..

    • @PPTVBA
      @PPTVBA  4 года назад +1

      Thank you very much! It's just creative out-of-the-box thinking with the simplest of codes.

  • @gurpreetsekhon151
    @gurpreetsekhon151 4 года назад +2

    You are going places!

    • @PPTVBA
      @PPTVBA  4 года назад

      Thank you!

  • @karlnikolasalcala8208
    @karlnikolasalcala8208 4 года назад +2

    ANOTHER GREAT VID!! THANKS!

    • @PPTVBA
      @PPTVBA  4 года назад

      Thank you very much! Was the tutorial understandable? I had to re-do this.

  • @katjaw9957
    @katjaw9957 4 года назад

    Wow.... It's great I will try this on weekend. Thank you very much I can learn a lot while watching your videos

    • @PPTVBA
      @PPTVBA  4 года назад

      Yay! Glad to help you out. My best wishes for a productive weekend!

  • @billminimum6695
    @billminimum6695 4 года назад +2

    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.

    • @PPTVBA
      @PPTVBA  4 года назад

      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!

  • @MeRealDreamer
    @MeRealDreamer 4 месяца назад

    what if only 1 slide for 5 question... what is the formula?

  • @al1453jj
    @al1453jj 2 года назад

    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 :)

  • @irinapolyakova4182
    @irinapolyakova4182 4 года назад +1

    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!

    • @PPTVBA
      @PPTVBA  4 года назад +1

      "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.

    • @irinapolyakova4182
      @irinapolyakova4182 4 года назад

      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! )))

    • @PPTVBA
      @PPTVBA  4 года назад

      @@irinapolyakova4182 can you please send me a mail with the same?

    • @irinapolyakova4182
      @irinapolyakova4182 4 года назад

      Ok

  • @thediamondpro5050
    @thediamondpro5050 4 года назад

    Thank you for your help

  • @onyinyemadumere6983
    @onyinyemadumere6983 4 года назад +1

    Bhavesh Sir. i really love your tutorials, is it possible to have virtual training with you please?

    • @onyinyemadumere6983
      @onyinyemadumere6983 4 года назад

      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?

    • @PPTVBA
      @PPTVBA  4 года назад

      You cant send me a message via my website!

  • @katjaw9957
    @katjaw9957 4 года назад

    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.

    • @PPTVBA
      @PPTVBA  4 года назад

      That's wonderful! Have a great weekend with PowerPoint and VBA!

    • @katjaw9957
      @katjaw9957 4 года назад

      @@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
      @PPTVBA  4 года назад

      @@katjaw9957 can you send the pptm to my email?

    • @katjaw9957
      @katjaw9957 4 года назад

      @@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.

    • @PPTVBA
      @PPTVBA  4 года назад

      @@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 &

  • @madhavpokhara
    @madhavpokhara 3 года назад

    So nice. The coding are difficult to visualize. Can you please give a link to copy the code

    • @PPTVBA
      @PPTVBA  2 года назад

      The link is the description! pptvba.com/fill-in-the-blanks/

  • @saurabhtulsyan4855
    @saurabhtulsyan4855 4 года назад

    Thank you for your prompt reply. Your tutorial is really fantastic. Today I received your email. Thank you very much.

    • @PPTVBA
      @PPTVBA  4 года назад

      Glad that the fill in the blanks module helped you out! Have a great day!

  • @wanhazirah47
    @wanhazirah47 3 года назад

    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

    • @PPTVBA
      @PPTVBA  3 года назад +1

      If you have only one slide: for i = 1 to 1.

    • @wanhazirah47
      @wanhazirah47 3 года назад

      @@PPTVBA thankyou so much, ure very genius

  • @taher172007
    @taher172007 4 года назад

    Can we control animation in PowerPoint by PowerPoint vba?
    thanks

    • @PPTVBA
      @PPTVBA  4 года назад

      Yes we can! But it becomes a bit tedious like that. I prefer to use trigger animations mostly.

    • @taher172007
      @taher172007 4 года назад

      @@PPTVBA thank you

  • @alvismar8389
    @alvismar8389 4 года назад

    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?

    • @PPTVBA
      @PPTVBA  4 года назад

      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!

  • @Joseorlando98
    @Joseorlando98 2 года назад

    You go too fast for a beginner to understand and follow. Please make a powerpoint presentation from scratch.

    • @PPTVBA
      @PPTVBA  2 года назад

      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:
      ruclips.net/video/OIpqD8TWSMw/видео.html