Find Us On: Facebook Twitter Rss Feed Blog
Need To Register? Sign Up Login

VBA CODE HELP

luisur
luisur 


The file Receivables.xlsx contains data on a company's receivables from its customers. Each row corresponds to a particular customer. It indicates the size of the customer (1 for small, 2 for medium, 3 for large), the number of days the payment has been outstanding, and the amount of the payment due. Develop a form that has the usual OK and Cancel buttons, plus two sets of option buttons SMALL, MEDIUM and LARGE, and the second set using Days or the Amount column to summarize. Then write appropriate code that captures these choices and displays a message listing the appropriate average. For example, if the user chooses small and amount, the message box should display the average amount owed by all small companies. Attachments Tags Clarifications

Answers