recording and running macros

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? Get Expert Help at an Amazing Discount!
Use Discount Code “Newclient”for a 15% Discount!”


Buy Custom Nursing Papers

The post recording and running macros appeared first on Student Homeworks.

#write essay #research paper #blog writing #article writing #academic writer #reflective paper #essay pro #types of essays #write my essay #reflective essay #paper writer #essay writing service #essay writer free #essay helper #write my paper #assignment writer #write my essay for me #write an essay for me #uk essay #thesis writer #dissertation writing services #writing a research paper #academic essay #dissertation help #easy essay #do my essay #paper writing service #buy essay #essay writing help #essay service #dissertation writing #online essay writer #write my paper for me #types of essay writing #essay writing website #write my essay for free #reflective report #type my essay #thesis writing services #write paper for me #research paper writing service #essay paper #professional essay writers #write my essay online #essay help online #write my research paper #dissertation writing help #websites that write papers for you for free #write my essay for me cheap #pay someone to write my paper #pay someone to write my research paper #Essaywriting #Academicwriting #Assignmenthelp #Nursingassignment #Nursinghomework #Psychologyassignment #Physicsassignment #Philosophyassignment #Religionassignment #History #Writing #writingtips #Students #universityassignment #onlinewriting #savvyessaywriters #onlineprowriters #assignmentcollection #excelsiorwriters #writinghub #study #exclusivewritings #myassignmentgeek #expertwriters #art #transcription #grammer #college #highschool #StudentsHelpingStudents #studentshirt #StudentShoe #StudentShoes #studentshoponline #studentshopping #studentshouse #StudentShoutout #studentshowcase2017 #StudentsHub #studentsieuczy #StudentsIn #studentsinberlin #studentsinbusiness #StudentsInDubai #studentsininternational