Thread: Using Command Buttons to Move Cursor

In my workbook I have a list of hyper links to different areas on the same sheet, I have inserted a floating command button and would like it to return the cursor to the top of the hyperlink list when clicked on. I have little experience with VBA and would appreciate any help that could be provided.

Thanks.

Hello Tobre,

Welcome to the Forum!

The code below will place "Z30" in the top left corner. Change this to the cell you will be using.

  With Range("Z30")
    ActiveWindow.ScrollRow = .Row
    ActiveWindow.ScrollColumn = .Column
  End With

or use Excel's buitlin facility:

Sub snb()
  Application.Goto sheets(1).Range("Z30"),True
End sub