Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help me write a VBA Macro with the following requirements!!! Write a VBA macro referencing the data on the VBA Problem Starting Data tab.

Please help me write a VBA Macro with the following requirements!!!

Write a VBA macro referencing the data on the VBA Problem Starting Data tab. Your macro should do the following. (Note: You should be able to complete all these tasks by running your macro one time. You will lose points if you must run your macro multiple times to complete the tasks.) a. Flip the sign for any negative values in the Amount Requested column. i. Ex/ -24,000 24,000 b. Highlight columns A K for each row according to these rules. (If everyone in your group is color-blind, please let me know.) i. The rows for Amounts Requested less than 3,000 should be green. ii. The rows for Amounts Requested less than 19,000 but more than 2,999 should be blue. iii. The rows for Amounts Requested more than 18,999 should be orange. c. Delete any record with an absolute value of Amount Requested more than 25,000. (i.e. more than 25,000 or less than -25,000) d. The macro should be triggered from a button located on the VBA Setup Instructions tab. e. Once complete, the macro should select cell A1 on the VBA Problem Starting Data tab.

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_2

Step: 3

blur-text-image_3

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

Options Futures And Other Derivatives

Authors: John Hull

9th Global Edition

1292212896, 9781292212890

More Books

Students also viewed these Accounting questions