Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Mar 2003
    Location
    Sydney, New South Wales, Australia
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Is there an Excel xlDialog that can be used to display the Goto dialog? The xlDialogSelectSpecial can be used to display the Goto special dialog, but I haven't been able to dinf a way of displaying the Goto dialog that shows when you click F5?

    regards
    Mark

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    In VBA Macro

    Application.Dialogs(xlDialogFormulaGoto).Show

    If you type Application.Dialogs(

    then you should see the Full list of Available Dialogue Boxes Appear

    Hope that is the one you want.
    Andrew

  3. #3
    Star Lounger
    Join Date
    Mar 2003
    Location
    Sydney, New South Wales, Australia
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks

Posting Permissions

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