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

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" wrote:

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

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

Ayman

"Mike H" wrote:

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" wrote:

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