Button that bring to different part of spreadsheet

[Jer-XL-emy]

Hi XL-perts,

I am looking for a button that once its pushed, it will bring me to another cell that will show different data located on the same spreadsheet - I am aware that there are 3 different buttons (toggle, forms, command) - I am sure I use either forms or command - how would I set that up - any ideas?

Thank you in advance and Happy New Year

 

[iggydarsa]

I used commandbutton and assigned this code to see the cell Z100

Private Sub CommandButton1_Click()
Range("Z100").Activate
End Sub

 

[Jer-XL-emy]

That worked great thank you very much iggydarsa, and than you for the qucik replay - Happy New Year