command button question

[P-C-Surgeon]

How do you create a command button near or in cell A1 so that when the button is clicked, it takes you to cell G100

 

[Macropheliac]

Add the following code to a standard module.

Sub GotoG()
Range("G100").Activate
End Sub

To do this:
1.) Press Alt/F11
2.) Click Insert / Module
3.) Paste the code.

Insert a command button from the forms tool bar.
To do this:
1.) Click the command button icon on the forms tool bar.
2.) Click the area to insert the button.
3.) Click the procedure
4.) Click OK

 

[P-C-Surgeon]

Your instructions worked well. Thanks for the help!