COMMAND BUTTON

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BOB - 11 Apr 2008 18:11 GMT

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.

Reply to this Message

Mike H - 11 Apr 2008 18:59 GMT

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

> 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.

Reply to this Message