Automate a Data Entry Form - Dynamic Arrays & Mixed Macro- Part B

This is Part B of the Project. You should have watched Part A first.
You can watch Part A, by clicking on the link:
• Automate a Data Entry ...
=============================================================================
Collecting data input should be user friendly and intuitive, avoiding confusion when entering data, then easily submitting to a report that keeps all records in sequence.
Whether it’s for student registration, event booking, Visa application, Driver’s license renewal… we deal with digital forms every day.
In this article I create and automate a user-friendly form for requesting a Corporate Training Course from the OfficeInstructor Training Centre. I will be using:
• Dynamic Array Functions
• Reverse Checkbox
• Picture Lookup
• Data Validation
• Mixed Macro recording
• Conditional Formatting
• And lots of Tips and Tricks along the way.
A Submit button only appears If the Form Fields are completed
With a click, all data is added to a general report that saves all records.
You can Download the Start File and Follow along by clicking on the Link here below:
officeinstruct...
You can also read the Step by Step Manual, by clicking on the link:
officeinstruct...
##################################################################
in Part A, We:
Create the structure of the Form
Enter Titles, Labels and Logo
Create 8 Drop Lists
Create a Data Validation Rule
Create 2 Option Buttons
Create the Reverse Check Box
Conditional Formatting to the Checkbox
==============================================================================
In Part B, We:
Create a Preparation sheet
Create Three Functions
Trigger the Submit Button
Naming Labels and Input Cells
Create Dynamic Array Functions
Build the Report
Recording a Mixed Macro
Assign the Macro and Test it
Finalizing the Form
Protecting the Form
####################################################################
To book a Corporate Training Anywhere in the world, Check:
www.OfficeInstructor.com
_____________________________________________________________________________________________
You can support my channel by liking, commenting and sharing my tutorials.
Don't Forget to SUBSCRIBE

[@colinhuntley9729]

mr mourad, yesterday evening i downloaded the file for part b! many thanks for providing this so quickly!

[@Officeinstructor]

You are welcome

[@nadermounir8228]

Thank u Nabil for this lovely video :)

[@patrickschardt7724]

Wonderful instructor. I always learn something new with every video. And also different ways to do things I already know This is a fantastic data entry form

[@Officeinstructor]

You are very welcome

[@gandhisunil3]

Superb🎉

[@Officeinstructor]

Thank you

[@colinhuntley9729]

many thanks, mr mourad, for two very inspiring tutorials. i have practicing for a couple of hours now, and i am very pleased with the results. i have one question: is the excel file download for part b also coming soon? once again, many thanks!

[@Officeinstructor]

Hi Colin, Thanks for the nice words and glad it was useful. YES the File and Manual are coming very soon (1-2 days) I didn't want to delay the video until then. Stay tuned

[@colinhuntley9729]

@@Officeinstructor mr mourad, your reply is much appreciated. i am practasing patience. looking forward to the file and manual. your input is very valuable to the youtube-excel community!