Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Need VBA equivalent for =FORMULA.GOTO?()

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.




  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    NY
    Posts
    1,056
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.


  4. #4
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Jassy


    Do you mean this:

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


  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •