Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
COMMAND BUTTON
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
COMMAND BUTTON
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command Button Help | Excel Discussion (Misc queries) | |||
Command Button | Excel Worksheet Functions | |||
VBA Command Button | Excel Discussion (Misc queries) | |||
command button | Excel Discussion (Misc queries) | |||
Command Button | Excel Worksheet Functions |