ExcelBanter - COMMAND BUTTON

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - COMMAND BUTTON (https://www.excelbanter.com/new-users-excel/183409-command-button.html)

I KNOW THAT THIS IS EXTREMELY BASIS, BUT I'M NEW SO PLEASE FORGIVE ME.
BUT....I NEED TO SET UP A COMMAND BUTTON TO MOVE TO A DIFFERENT TAB. HOW DO
I DO THAT? I HAVE THE BUTTON, BUT NOT SURE WHAT TO DO AFTER THAT.

First and most important you tap the caps lock key to stop typing in capitals
then you do this

Right click the button and view code and then paste this in

Private Sub CommandButton1_Click()
Sheets("Sheet1").Select
End Sub

change the name of the sheet to the one you want.

Mike

"BOB" wrote:

I KNOW THAT THIS IS EXTREMELY BASIS, BUT I'M NEW SO PLEASE FORGIVE ME.
BUT....I NEED TO SET UP A COMMAND BUTTON TO MOVE TO A DIFFERENT TAB. HOW DO
I DO THAT? I HAVE THE BUTTON, BUT NOT SURE WHAT TO DO AFTER THAT.