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