Under the Charts tab and using the data found on the Q2 - ChartData worksheet, create a UserForm that allows the user to display one of three charts of their choice the data from the ChartData worksheet as an image in the UserForm.

The Q2 - Exceptions worksheet contains monthly sales totals for a number of sales regions. Use the button located below the data to open the Exceptions page of a MultiPage UserForm to access a UserForm like the example shown. Use vbRed or Red, vbBlue for Blue and vbGreen for Green in your code. Basically this solution will allow you to choose one of three colors for the low values it the table, one of three for the high values in the table and will apply these rules when the OK button is clicked

Solution PreviewSolution Preview

These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice. Unethical use is strictly forbidden.

Investment Category Assets
Cash                               $7,360
U.S. Stocks                     $49,250
Non-U.S. Stocks             $9,715
Bonds                              $15,177
Other                              $7,144
Total Assets                   $ 88, 646 mil...

By purchasing this solution you'll be able to access the following files:

50% discount

$100.00 $50.00
for this solution

or FREE if you
register a new account!

PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

Find A Tutor

View available Visual Basic Programming Tutors

Get College Homework Help.

Are you sure you don't want to upload any files?

Fast tutor response requires as much info as possible.

Upload a file
Continue without uploading

We couldn't find that subject.
Please select the best match from the list below.

We'll send you an email right away. If it's not in your inbox, check your spam folder.

  • 1
  • 2
  • 3
Live Chats