Project #6: Adding VBA Code to the Add Worksheet Button

 To add VBA code to the Click event of a button that adds a worksheet in Excel VBA, follow these steps:

Open the Visual Basic Editor (VBE): Press Alt + F11 in Excel to open the VBE.

Open the User Form or Worksheet Code Module: Depending on where the button is located, you'll either open the code module for the User Form or the Worksheet where the button resides.

If the button is on a User Form:

Double-click on the User Form object in the Project Explorer window to open the User Form in design view.

Right-click on the button and select "View Code" from the context menu.

If the button is on a Worksheet:

Right-click on the Worksheet object in the Project Explorer window where the button is located.

Select "View Code" from the context menu.

Select the Click Event: In the code window, you'll see the button's name listed in the left drop-down menu and the available events in the right drop-down menu. From the right drop-down menu, select "Click". This will create a new subroutine for the Click event of the button.

Write VBA Code: Write your VBA code inside the subroutine for the Click event. This code will run automatically when the button is clicked.

Test the Button: Close the VBE and return to Excel. Click the button to trigger the Click event and execute the code.

Here's an example of how you can write VBA code for the Click event of a button that adds a new worksheet:

Private Sub CommandButton1_Click() 
' Add a new worksheet 
Dim ws As Worksheet 
Set ws = ThisWorkbook.Sheets.Add(After:=ThisWorkbook.Sheets(ThisWorkbook.Sheets.Count))
    ws.Name = "New Worksheet" 
' Optionally, perform additional actions on the new worksheet 
' For example, populate the worksheet with data or format it 
End Sub

In this example, when CommandButton1 is clicked, a new worksheet is added to the workbook with the name "New Worksheet". You can customize this code to fit your specific requirements and perform additional actions on the new worksheet if needed.