recording and running macros

/in /by

Unit Outcomes:

  • Add the developer tab to a workbook.
  • Create a basic macro.
  • Use the VBA command to determine a monthly payment.
  • Create a print button.

Course Outcome:

IT153-4: Create macros to automate worksheets.

Purpose

In this assignment, you will practice what you learned about creating macros using Visual Basic Application (VBA).

Assignment Instructions

Scenario:

Richie’s Subprime provides financing for customers who lack the usual down payments for a loan. The chief financial officer has asked you to automate the entry of financing data into a worksheet that computes the monthly payment and total cost of a loan.

Assignment Requirements

Preliminary Steps:

  1. Start Excel. If the Developer tab does not display on the Ribbon complete the following steps:
    1. Select File | Options. The Excel Option dialog box appears.
    2. Click on Customize Ribbon. The Customize Ribbon dialog box appears.
    3. Check the Developer Option check box in the right pane.
    4. Press the OK button. The Developers tab now appears on the Ribbon.
  2. Enable macros by completing the following steps:
    1. Click on the Developer tab.
    2. Click the Macro Security button. The Trust Center dialog box appears.
    3. Click ‘Enable all macros’.
    4. Press the OK button.

Please see the attached data file also.

 
Looking for a similar assignment? Our writers will offer you original work free from plagiarism. We follow the assignment instructions to the letter and always deliver on time. Be assured of a quality paper that will raise your grade. Order now and Get a 15% Discount! Use Coupon Code "Newclient"