Write a macro and userform in excel for the following problem.

Calculate if a tank will overflow in a given amount of time when given the specific measurements. The check box will let you choose which geometrical object you will use as your tank ( cylinder, box, Triangle). You should be able to choose one or all shapes and receive answers for them.The measurements will include radius, Length, Width, height. The macro should include the formulas for calculating flow rate. Text boxes will allow for you to enter a numerical number for each variable. Calculate the volume of the tank and the volume of the liquid to go along with the final calculation. My option box will include the units for each variable ( feet, inches, meters, centimemeters).

The macro MUST perform the following:

Have a specific purpose

The macro can not just be arbitrary entries and calculations. It must be created with a specific purpose in mind.

The purpose may include images and text, and must include the name of the macro creator.

Call a userform with a minimum of the following:

2 - Text Entries

1 - Set of Checkboxes

1 - Set of OptionBoxes

4 - Numerical Entries

Use default text and numerical entries.

Macro Calculations:

Calculations must be performed in the macro.

Must perform a minimum of 2 different calculations depending on which OptionBox is checked. (Hint: use if statement)

Perform Formatting of Excel Sheet from scratch:

The formatting macro must be created separate from the rest of the macros and called with the Application.Run command.

The only items visible on the sheet should be the purpose of the macro and 2 buttons, one to perform the macro and one to clear the results, which should clear all formatting and return the sheet to only 2 buttons and the purpose.

The following must be printed at the bottom of the page

Date - This must display the current date (there is a specific function for this)

Time - Display the current time

Displaying information and results on an 8.5 x 11 size sheet.:

The formatting should be set such that clicking print will result in 1 page sheet with all information and results listed.

Also use a chart to graph results from the macro