create a button to take me to a certain cell

[kancherlapv]

Hello,
Im a beginner so forgive my question. i created a button but i dont know the code. when i click the button, i need it to take me to the front of my worksheet to cell A30. can someone please help. thank you. -pk

 

[c_m]

create a button using forms toolbar and assign this macro to it:

Sub button_click()

Range("A30").Select

End Sub

 

[Sal Paradise]

Private Sub CommandButton1_Click()
    Application.Goto Reference:=Worksheets("Sheet1").Range("A30"), Scroll:=True
End Sub