command buttons

[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

 

[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

 

[Ayman]

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

Ayman