Moving in a worksheet with the use of Command Buttons

[Blanchetdb]

I presently have a lengthy document that has titles, in an Index, at the beginning of the document. How can I use command buttons with each subject so that when selected , it brings the reader to a specific row in the document?

Person selects the "HR" Command Button - it brings the person to the section (row) of the document that talks about HR

I presently using the following to navigate from one sheet o another:

Sub Activate_Worksheet_HRSD()
ThisWorkbook.Sheets("HRServicesDirectorate").Activate
End Sub

please help!

 

[steve the fish]

Heres how you could go to cell A50 on a sheet named Sheet2.

Application.Goto Sheets("Sheet2").Range("A50"), True