Question
Make form with a button, 2 labels (both hidden), a datetime picker and 2 textboxes. (*If your VBA does not have a datetime picker you
Make form with a button, 2 labels (both hidden), a datetime picker and 2 textboxes. (*If your VBA does not have a "datetime picker" you should research how to get one or find an alternative solution.) With this form, your goal is to capture a student's first name, last name and major (via an input box) and date of birth so that you are able to compute his/her age. Once the user has input the data, the form should show a label stating students first name, last name and major. A seperate label should show the student's computed age. Once this data is captured, store it on worksheet called "Students" in an appropriate manner. Data that is input into the form should begin under the headers and each subsequent entry should be captured below the previous entry. (**Note, you will have to research this step - research is an invaluable coding skill and a major learning objective of this class**)
Can you make this in EXCEL VBA File step-by-step, please? this is all the information we get.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started