Written by Debra Dalgleish from Contextures Blog
If you download one of the sample Excel workbooks from my Contextures website, you might want to customize it, to meet your requirements. The two videos below show how to customize one of my files, and you can make similar changes in other workbooks.
Excel Data Entry Form
These videos show how to make changes to the Worksheet Data Entry Form workbook.
It’s a popular download on my site, and people had questions about customizing it.
Customize the Worksheet Setup
The sample workbook has a sheet where you can enter data, and the first video shows how you can make changes to the worksheet setup.
For example, you might need to add another field with a drop down list of items.
Video: Customize Worksheet Setup
To see how to customize the worksheet setup in the sample file, watch this short video.
For written steps and screen shots, go to the Worksheet Data Entry page on my site.
Change Sheet Names in Code
Another thing that you might need to change, when you’re customizing one of the sample files, is the VBA code in the workbook.
In the Worksheet Data Entry file, if you change the sheet names, you’ll need to change the code, so Excel knows where to work its magic!
Two Options for Sheet Names
The video below shows 2 options for changing the sheet names in the code.
- Change the sheet tab names in the code, with find and replace
- Use sheet code names, instead of sheet tab names, for a better solution to the problem
You can apply the same techniques in other Excel VBA code, if you’re customizing a workbook for your own use.
Video: Change Sheet Names in Code
To see the steps for changing the sheet names in the code, watch this short Excel video tutorial.
For written steps and screen shots, go to the Worksheet Data Entry page on my site.
NOTE: The video timeline is below the video
Video Timeline
- 0:00 Intro
- 0:59 View the Code
- 2:10 Two Options
- 2:58 Find and Replace
- 4:55 Use Code Names
- 7:26 Get the Workbook
Get the Worksheet Data Entry Form
The zipped sample workbook can be downloaded from the Date Entry and Update form page on my Contextures site.
There are several versions of the worksheet data entry form, available for download. Check the descriptions, and get the file that most closely matches your requirements.
____________________
Change Sheet Names in Excel Macro Code
____________________
____________________
Change Sheet Names in Excel Macro Code is a post from Contextures Blog and is not allowed to be copied to other sites
Original source: https://contexturesblog.com/archives/2019/09/26/change-sheet-names-in-excel-macro-code/