View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default 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