Command button

[SpecialK]

I want to add a button on a worksheet so when I click the button it will go to another sheet. Can I do that?

 

[Drmwvr7266]

I think that's simple enough. If you don't know where to start, here's how:

Click on VIEW, TOOLBARS, and CONTROLBOX.
Select the Command button option and place it on your worksheet.
Doubleclick it and the following will appear:

Private Sub CommandButton1_Click()

End Sub


In between the ComandButton_Click and End Sub, type this:

Sheets("Your sheet name here").Select


That's it! Your sheet name will have to be between quotation marks as shown.
This message was edited by Drmwvr7266 on 2002-08-25 05:46

 

[SpecialK]

Thanks for helping. I tried but it says "Cannot run visual basic macro because of a syntax error".

 

[Drmwvr7266]

Private Sub CommandButton1_Click()

Sheets("Your sheet name here").Select

End Sub

Does your code look like this?VB is particular about the way you write it. You need to make sure it is written correctly. If your sheet name is, say, Sheet1, then it should read:
Sheets("Sheet1").Select.

Note: After the ("Sheet1") is a period, then SELECT.
This message was edited by Drmwvr7266 on 2002-08-25 05:56

 

[SpecialK]

yes it worked, thanks a lot