Answered step by step
Verified Expert Solution
Question
1 Approved Answer
To demonstrate your competence with navigating a worksheet with VBA, download the Excel workbook file below, Lastname.VBA.Navigation.HW . xlsm . Name the file using your
To demonstrate your competence with navigating a worksheet with VBA, download the Excel workbook file below, Lastname.VBA.Navigation.HWxlsm Name the file using your last name. For example, a student with the last name of Jones would name the file Jones.VBA.Navigation.HWxlsm use your last name Then, complete the steps below, writing your code in Module which has already been created for you.
Write code rather than recording a macro to do the following:
Make E the active cell
Set the value of the active cell to "CIS
Offset rows and columns, and make that the new active cell
Set the value of the new active cell equal to your last name
Offset rows and columns, and make that the new active cell
Set the value of the new active cell equal to your first name
Make the cell furthest up from the current active cell the new active cell use endxlUp
Set the value of the new active cell equal to your professors last name
Activate Sheet
Set the value of cell A equal to your desired or current major
Return to cell A on Sheet
Make all of this code run in a single subroutine that is triggered by the button on the first worksheet.
When it is completed, upload your saved workbook below.
Be sure to write your code in Module in the workbook you will submit.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started