Answered step by step
Verified Expert Solution
Question
1 Approved Answer
For VBA excel please. The Excel file 230-Hwk07.xslx contains data on a company's outstanding accounts from different customers. Each row corresponds to a particular customer.
For VBA excel please.
The Excel file 230-Hwk07.xslx contains data on a company's outstanding accounts from different customers. Each row corresponds to a particular customer. It indicates the shirt size of the customer (1 for Small, 2 for Medium, 3 for Large), the transaction date in 2013, the number of shirts ordered and the amount of the payment due Develop a user form that has the usual OK and Cancel buttons, two sets of option buttons and a list box. The first set of option buttons allows the user to choose the size of the customer (using captions Small, Medium and Large and the second set allows the user to choose the column to summarize i e., Number of shirts purchased or the Amount. The list box lists the twelve months of the year and allows the user to select one or more months to be summarized. Then write code in a sub called Summarize placed in a module that takes the choices made in the form and displays a message listing the appropriate information and average number or amount. The Sub Summarize should be called from a button placed on the worksheet with the data. The sub will call the form described above. The form should be inside a do loop and be called until the cancel button on the form is clicked. The options selected in the form should be preserved between calls to the form. The form should have your full name in the title bar. Also the message boxes will have your full name in the title bar. The average for number should be reported with a number with two significant digits and the average for amount should be displayed as currency with two significant digits. The following illustrates the screen captures that you will need to submit in the worksheet "Captures". To capture the images pressStep 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