Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Problem 1 . At the registration area of the 2 0 2 3 BCT Meeting, a large convention of building contractors, organizers ask convention participants
Problem At the registration area of the BCT Meeting, a large convention of building contractors, organizers ask convention participants about their name and years of experience in the industry The come manager would like to have a computer program to classify people according to their experience. You are required to design a friendly user form with the following features: A text box to input the name of a pers attending the convention. A text box to input the registration number of the person a numeric code with at least four digits, but no more than digits A spin button ranging from to for the years of exper default is A button entitied "Classity". Place a button on the sheet containing the data to open the application remember not to place this button so that it will obstruct the view of the dalaset The progam check that the registration number is correct, that is it has at least four numeric digits, but no more than numeric digits If the code is incorrect, then the program must display an error message on a message use the isNumeric function When the user presses the "Classify" button, and if the code is correct, the program will classify the person by placing the name and registration number in the corresponding columin o sheet as illustrated in Figure The input in the cell must have the format For example, Erik Neud reg no Charies Bo reg no and Daniel Mok reg no have years of experience each, they should be placed in column
K
of the sheet, corresponding to people with years of experience. If a person has or more years of experience, heshe should be placed in the last column column U Notice that the columns may have diftere number of entries, so that you need to keep separate counters for each column.
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