command buttons

A

Ayman

I want to put a command button that just takes me to a cell in the
spreadsheet when i click it. for example, if i want to scroll to cell G50 to
view phillies statistics, all i have to do is click the command button that
says phillies statistics, but it is programmed to just go to cell G50.

Thanks,
Ayman
 
M

Mike H

Hi,

Put a button on your sheet and change the caption to "phillies statistics".
View code and the code for the button is

Application.Goto Range("G50")


Mike
 
A

Ayman

Thank you so much. It was so simple, just had no idea what the code was.
Worked perfectly.

Ayman
 
Top