Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

image text in transcribed

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 press

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Time Series Databases New Ways To Store And Access Data

Authors: Ted Dunning, Ellen Friedman

1st Edition

1491914726, 978-1491914724

More Books

Students also viewed these Databases questions

Question

What is the finite population correction? When can it be ignored?

Answered: 1 week ago