How to create FILL IN THE BLANKs in PowerPoint - Interactive Game [PPT VBA Tutorial]
Published 2020-04-08
Fill in the Blanks - PowerPoint Game VBA CODE: pptvba.com/fill-in-the-blanks/
FEATURES:
✅ Multiple Blanks
✅ Report Card + Grade + Points
✅ Countdown Timer
✅ Send Data to Excel
✅ Shuffle, Multiple Attempts, MsgBox
✅ Flag Questions for Review
This module allows the student to type the answer in an ActiveX Element TextBox.
We later cross-check the answer with the correct answer which is stored inside a shape placed outside the slide! We do this with the help of an If-Then-Else Conditional Statement.
It is very unconventional but it allows the teachers to quickly modify this template and change the correct answer without bothering them with any Visual Basic Codes and Macros.
ActiveX Element - TextBox in PowerPoint
This is a very versatile tool for teachers and educators if you want to collect input data from your students.
By using the TextBox1.Value function, we can read the input data which your student has typed.
Then, we use an If-Then-Else condition statement to crosscheck the Input Answer with the Correct Answer.
#PowerPointGame
One Code for Hundred Slides
This is what makes my tutorial and code stand out from the rest of the modules. Conventionally, we would not use a shape to store data but it is extremely convenient and feasible. Instead of storing the data inside a shape that is placed outside the slide, programmers would use an Array to store all the answers but that would not be the best course of action in terms of ease for customisability.
I also do freelancing, contact me:
Bhavesh Shaha,
[email protected]
youtube.com/bhaveshshaha
www.instagram.com/basicallybhavesh (DMs are open)
Music by Ashwin Subramanian
/ @ashwathamamusic
All Comments (21)
-
I've been watching your video tutorials many times...and I was so impressed with your project. Continue to share your heavenly talent.God bless
-
Apt teaching for even a beginner to understand with clarity. Well Done !!!
-
These tutorials are brilliant! Thank you for sharing 🙏💜
-
I'm incredibly impressed by a video showcasing a game created with PowerPoint. The creativity and innovation demonstrated in using such a tool for game development are truly remarkable. It's both entertaining and inspiring!
-
Thank you very much.!! Everything is so clear after watching Your explanations!👌👏
-
I'm brazilian and I your video helped me. Thank you so much!!!!
-
Wow! You’re a genius, thank you for sharing your talent.
-
New follower from Philippines 🇵🇭😁 thank you for the tutorial sir. It will help me a lot during this time of pandemic during my teaching. More blessings and power to you for helping us teachers 😊
-
Thank you very much. I have a very bad english as you can learn, but with your video I have understand. You have really help me. Thank you again.
-
Thank you so much! This helped a lot!
-
You are awesome, dude! Thanks!
-
Thank you very much I''m not developer but I have to do these kind of thinks for my son And you have help a lot God bless you
-
Thankyou so much!! This helps me a lot new subscriber here
-
Wonderful. I wanted this.
-
Thank you for sharing your amazing idea 🤗
-
Thank's bro it's wonderful
-
This is useful thank you 😊
-
Thank you for a great idea 🙏💡
-
Thats great!!
-
I think these codes are similar to python codes. Didn't knew powerpoint has this feature. Wow! Praise your work