Question: In your workbook HW 1 . xlsx , assign code name wsFirst to the worksheet Sheet 1 and assign code name wsSecond to the worksheet

In your workbook HW1.xlsx, assign code name wsFirst to the worksheet Sheet1 and assign code name wsSecond to the
worksheet Sheet2.
Write a VBA sub which does the following:
o Asks the user to input a string of at least ten characters
o Change the tab name of the worksheet wsFirst with the first 5 characters which were entered
o Change the tab name of the worksheet wsSecond with the last 5 characters which were entered.
Make sure that the subroutine you write can work multiple times.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!