command button question

P-C-Surgeon

Board Regular
Joined
Sep 24, 2004
Messages
115
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
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Macropheliac

Board Regular
Joined
Aug 26, 2005
Messages
165
Add the following code to a standard module.

Code:
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
 

Watch MrExcel Video

Forum statistics

Threads
1,114,674
Messages
5,549,358
Members
410,910
Latest member
DessertDiva
Top