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

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