Step 1
Insert a form button from developer tab as in image. If you don't see a develop tab...activate it from file -> options -> customized ribbon
Step 2
When you create a button, it will ask you to create a macro....click new
Step 3
It would take you to macro editor window. Write macro like this -
Here is the code for you to copy paste...fill in your sheet name & cell number
Sub Button2_Click()
Sheets("Sheet Name").Select
Sheets("Sheet Name").Range("Cell Number").Select
End Sub
Step 4
Close the macro editor...come back...test your button. Dance now! :)



No comments:
Post a Comment