Need VBA equivalent for =FORMULA.GOTO?()

[jassy]

I'm new to VBA, trying to learn more by converting old macro.

The function "=FORMULA.GOTO?()" in Excel XLM is same as the "Go To" command in Excel. It will open a dialog box with all range names created in the workbook. The user can scroll the up-down bar to select **ANY** range name to goto without typing the reference.

The VBA command (Application.Goto Reference:=) only goto the specified range.
What will be the equivalent function/command in VBA to give you the choice to goto without typing?

Thanks to your help.

 

[BobUmlas]

Application.Goto Range("Whatever")
If you include ", True" at the end, it will bring the active cell to the upper left corner:
Application.Goto Range("Whatever"), True

 

[jassy]

Bob,

Thanks to your reply. The Application.Goto Range("Whatever") only goto the range name "Whatever" specified in this command line.

I'm looking for a way to list all range names for user to select and goto. Please help again.

 

[Dave Hawley]

Hi Jassy


Do you mean this:

Sub GoWhere()
Application.Dialogs(xlDialogFormulaGoto).Show
End Sub

 

[jassy]

Dave, Thanks to your help. This is what I'm looking for.