VB subroutine

Click Here to Download this Answer Instantly

This document provides you a background of how to use Excel’s macro recording capability. By using the macro recorder you can generate an initial VB subroutine that can then be enhanced to create a custom user interface to the data and functionality stored in a spreadsheet.For example, the subroutine recorded in the tutorial is shown at the end of the tutorial. This VB subroutine created by the macro recorder creates a User Form to enter expense data for a user.Details:For this project, I am asked to create the User Form to enter data which will automatically place it in the spreadsheet. There are additional ideas to add to this assignment at the end of the document. This assignment provides you what you can do with VBA.