Kindly use microsoft VBA excel ASAP

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

Kindly use microsoft VBA excel ASAP

Refer to below userform as reference. Accomplish the following instruction in designing the
userform and it's function. Creativity is highly encouraged to design a more unique
userform to improve the users' experience (colors and fonts may be changed, images, toolbox
controls, message box added, etc.).
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
28
29
30
31
32
Employee ID
100 Jim
101 Jack
102 Cathy
First Name
Smith
Rose
Nelson
Employee Form
Last Name
Employee ID
First Name
Last Name
Date of Birth
Email ID
Passport Holder
Submit
102
Date of Birth
Cathy
Nelson
27
Yes
1-Feb-82 jim@Tutorialspoint.com
19-Aug-88 Jack.Rose@Tutorialspoint.com
27-Jul-86 cathy@tutorialspoint.com
JUL
cathy@tutorialspoint.com
1986
@No
Email ID
Cancel
Yes
No
No
Passport Holder
Pressing the Submit button in the userform will record the information into the Excel
worksheet
Change the Employee ID into Student No.
ListBox values for the year should be from years 1970 to 2020 only
Test the program by entering all group member's information (other details maybe
bogus for privacy reasons)
Transcribed Image Text:Refer to below userform as reference. Accomplish the following instruction in designing the userform and it's function. Creativity is highly encouraged to design a more unique userform to improve the users' experience (colors and fonts may be changed, images, toolbox controls, message box added, etc.). 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 28 29 30 31 32 Employee ID 100 Jim 101 Jack 102 Cathy First Name Smith Rose Nelson Employee Form Last Name Employee ID First Name Last Name Date of Birth Email ID Passport Holder Submit 102 Date of Birth Cathy Nelson 27 Yes 1-Feb-82 jim@Tutorialspoint.com 19-Aug-88 Jack.Rose@Tutorialspoint.com 27-Jul-86 cathy@tutorialspoint.com JUL cathy@tutorialspoint.com 1986 @No Email ID Cancel Yes No No Passport Holder Pressing the Submit button in the userform will record the information into the Excel worksheet Change the Employee ID into Student No. ListBox values for the year should be from years 1970 to 2020 only Test the program by entering all group member's information (other details maybe bogus for privacy reasons)
Expert Solution
steps

Step by step

Solved in 10 steps with 12 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY