Create an input form without a userform or VBA in Excel
If you're not proficient in VBA or simply don't have the option to use userforms in Excel, and you want to create a custom data entry form to populate your database, then you'll need to use another feature that will allow you to do this.
So here we have a client who's asked us to create a data entry form that will allow their users to add a country, city, and postal code to the database. But that's not all, because our client wants each entry in the database to be identified by a unique reference number, and this number must be generated automatically after each new entry.
The postal code entry must be numeric, and we need a visual indicator to show if the postal field is not correctly filled in.
The client also wants their database and data entry form to be protected to prevent users from making changes to the data entry form or entering data into the database.
And finally, he'd like the form submission button to appear only when all the form fields are filled!
00:00 - Intro
01:24 - Form creation
04:55 - Form and data mapping
06:45 - Validation
09:58 - Save button
14:38 - ID
16:57 - Page protection
18:02 - Save macro
The Excel file is available to channel members, so what are you waiting for?
The Excel file is available for channel members, so what are you waiting for? / @tutoderien
Join this channel to get access to exclusive perks:
/ @tutoderien
#TutoDeRien
Website: https://www.tutoderien.com
Subscribe to the channel and we'll see you in the next video!