Create an excel data entry form - NO VBA required
In this video, we show how to build an excel data entry form with no vba. And after we build the excel data entry form, we add some data validation rules in order to enforce correct data entry through our excel data entry form. This video is full of tips and tricks about building an excel data entry form and it's a video you don't want to miss!
Download Example Files:
http://tinyurl.com/mrxkz2h3
⭐Check out my Courses:
ExcelBonanza.com/Courses
Excel PowerPivot for beginners Course:
https://abdelrahman-s-site-cb54.think...
🎁Use discount code YOUTUBE15 at checkout (Limited time offer!)
TIMESTAMPS:
00:00 Introduction
00:33 Adding the form tool or command to the quick access toolbar
01:44 Preparing our data by creating an Excel table
02:38 Using the data entry form
06:02 Creating data validation rules to control the data entered through the form
12:30 Cool tip: Create a separate tab in Excel containing the form command or tool
13:45 Conclusion
Follow us on Social Media:
Facebook: / excelbonanza
Twitter: / excelbonanza
Follow me on Linkedin: / abdelrahman-abdou-60240150
Instagram: / excelbonanza1
TikTok: / excelbonanza
Telegram: https://t.me/ExcelBonanza
Website: https://www.ExcelBonanza.com
****My online Excel Courses****
https://www.excelbonanza.com/courses/
