Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Code for Command Buttons
I want my command button to take me to a cell in a different sheet, same
excel file. For example, in sheet one, i have 9 command buttons. First Command Button takes me to cell "A1" in sheet 2, second takes me to cell "A 150" in sheet 2, etc. What is the code for the command button to do this? I know the code for the button to take me to a cell in the same sheet, just not to a cell in a different sheet. Please help! Thank You, Ayman Al-Qasem |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Code for Command Buttons
Try something like this:
Sheets("Sheet2").Select Range("A150").Select -- Kevin Backmann "Ayman" wrote: I want my command button to take me to a cell in a different sheet, same excel file. For example, in sheet one, i have 9 command buttons. First Command Button takes me to cell "A1" in sheet 2, second takes me to cell "A 150" in sheet 2, etc. What is the code for the command button to do this? I know the code for the button to take me to a cell in the same sheet, just not to a cell in a different sheet. Please help! Thank You, Ayman Al-Qasem |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command Buttons | Excel Discussion (Misc queries) | |||
Excel Command Buttons | Excel Worksheet Functions | |||
Command Buttons | Excel Discussion (Misc queries) | |||
Help with command buttons | Excel Worksheet Functions | |||
command buttons | Excel Worksheet Functions |