Answered step by step
Verified Expert Solution
Link Copied!

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.HW.xlsm. Name the file using your last name. For example, a student with the last name of Jones would name the file Jones.VBA.Navigation.HW.xlsm (use your last name). Then, complete the steps below, writing your code in Module1, which has already been created for you.
Write code (rather than recording a macro) to do the following:
Make E6 the active cell
Set the value of the active cell to "CIS 200"
Offset 2 rows and -3 columns, and make that the new active cell
Set the value of the new active cell equal to your last name
Offset -2 rows and 2 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 .end(xlUp))
Set the value of the new active cell equal to your professors last name
Activate Sheet2
Set the value of cell A1 equal to your desired or current major
Return to cell A1 on Sheet1
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 Module1 in the workbook you will submit.

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

Step: 3

blur-text-image

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

Modern Database Management

Authors: Jeffrey A. Hoffer Fred R. McFadden

9th Edition

B01JXPZ7AK, 9780805360479

More Books

Students also viewed these Databases questions

Question

Learn How to Manage Execution cmd Drive for Results.

Answered: 1 week ago