Command Buttons

[Mommom]

I would like to know how to create a command button that will open up another worksheet. In the same workbook and in a different workbook.

Thanks for any help.

 

[Smitty]

Welcome to the Board!

For the first you can use:

Sub CommandButton1_Click()
  Sheets("Sheet1").Activate
End Sub

The second you can record and assign to a Forms button. That way the VBE will capture the correct file path for you.

Hope that helps,

Smitty

 

[Mommom]

Forgive me for being confused but I am new at doing this. I created the command button, double clicked on and placed this code

Private Sub CommandButton1_Click()
Sub CommandButton1_Click()
  Sheets("Circuits Sites").Activate
End Sub

Can you also explain the second one. I am not sure how to do the statement below:

The second you can record and assign to a Forms button. That way the VBE will capture the correct file path for you.

 

[Smitty]

Sorry, that should have been "Private Sub".

The error in your code is the two Sub lines. It should look like this:

Private Sub CommandButton1_Click() 
  Sheets("Circuits Sites").Activate 
End Sub

As for the second, if you record a macro opening up another wb, VBA will record the correct file path (location) and syntax for you. You can then draw a button on the sheet from the Forms toolbar. As soon as you're done drawing it, you'll get a menu dialog. One of the options is Assign Macro. Select the recorded macro. Now when you click the button, the macro will fire.

Smitty

 

[Mommom]

I have tried this

Private Sub CommandButton1_Click()
Sheets("Circuits Sites").Activate
End Sub

the only this and it is still not working. The command button just keep just keeps opening up the code. Is there something else I am suppose to do in order to enable the button to start working?