Command Buttons & ActiveX Controls

[aussiegirlone]

What I would like to do is have a command button on click, to go to another
sheet on a specified cell range in the same workbook. It’s just that I do not
know how to create macros or codes to make any command button work. Any help
me would be much appreciated.

 

[Bob Phillips]

Public Sub MyButton_Click()
Worksheets("Sheet2").Select
End Sub

 

[Dave Peterson]

And to get to a specific range:

Public Sub MyButton_Click()
application.goto Worksheets("Sheet2").range("X99"), scroll:=true 'or false??
End Sub