Question: e QUESTION 2) Create a Sub that: Display an input box with prompt Please enter your birth year Get the user input into a VBA

QUESTION 2) Create a Sub that: Display an input box with prompt "Please enter your birth year" Get the user input into a VBA Variable If the value entered by user is not numeric, display a message box saying "Please enter a number" Else if the value is numeric, calculates the age of the user If age is greater than 30, display a message box saying "Too Old!!!" Else if age is less than 18, display a message box saying "Too Young!!!" Else display a message box saying "Perfect!" QUESTION 2) Create a Sub that: Display an input box with prompt "Please enter your birth year" Get the user input into a VBA Variable If the value entered by user is not numeric, display a message box saying "Please enter a number" Else if the value is numeric, calculates the age of the user If age is greater than 30, display a message box saying "Too Old!!!" Else if age is less than 18, display a message box saying "Too Young!!!" Else display a message box saying "Perfect

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Mates Rates Rent-A-Car ( just do the part a) using visual studio code (C#) Criteria sheet - Par A Example supplementary files (readme.pdf) Example supplementary files (class-diagram.pdf) Assignment...

Please provide a screenshot of the output once you run it. Thanks in advance. Create a program for managing an employee database. The required functionality is: 1) An Employee class, with the...

Java. Please show SCREENSHOT of output so I can see how the output is coming out. Create a program far managing an employee database. The required functionality is: 1 An Employee class, with the...

IN JAVA AND PLEASE PROVIDE SCREENSHOTS OF THE OUTPUT. Car Garage and Driving Project Part 1: Create Car and Garage classes in accordance with the following specifications. I have provided the...

Create a program for managing an employee database. The required functionality is: 1) An Employee2 class, with the following methods and attributes: a) Data members: firstName (String), lastName...

The program should be implemented as a single file containing both classes. Create a program for managing an employee database. The required functionality is: 1) An Employee class, with the following...

Assignment Create a program for managing an employee database. The required functionality is: 1) An Employee class, with the following methods and attributes: a. Data members: firstName (String),...

Can someone help me with this C++ programming assignment thanks. I have provided some partial code at the bottom but I need to add some functions listed below. I have to create two different classes....

6.2 Question 2 Create a package named Q2. Recycle the Q3 from Lab#4. Create a calculator program to perform arithmetic operations on complex numbers. Create a java class named ComplexNumber, as shown...

Sam is in his second year of college enjoying his freedom from his nagging mom. Since he has been living on his own, he eats anything he wants to. He eats rarely eats any vegetables. He has bacon &...

Your firm has limited capital to invest and is therefore interested in comparing projects based on the profitability index (PI), as well as other measures. What is the PI of the project with the...

True or false buying on credit is almost always cheaper than paying cash

If the following join statement is used to join two tables in a query, which of the following tables would all of the tuples in the relation appear in results? left join university.students on...