Question: 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 convention 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 person 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 experience, default is
A button entitled "Classify".
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 dataset
The program must 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 box Hint: 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 column of the sheet as illustrated in Figure The input in the cell must have the format the sheet, corresponding people with years experience. a person has more years experience, should placed the last column Notice that the columns may have different number entries, that you need keep separate counters for each column.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
