+ Reply to Thread
Results 1 to 2 of 2

application.dialogs(xldialogsformulafind).show and then some ...

  1. #1
    Peter
    Guest

    application.dialogs(xldialogsformulafind).show and then some ...

    Hello everyone,

    Can someone let me know how to get the Find dialog on screen with the option
    for looking in values pre-selected ?

    Thanks,
    Peter
    Excel 2000



  2. #2
    Dave Peterson
    Guest

    Re: application.dialogs(xldialogsformulafind).show and then some ...

    Like this??

    Dim myStr As String
    myStr = "What should I find"
    Application.Dialogs(xlDialogFormulaFind).Show myStr

    You can type in application.dialogs and select .dialogs and hit F1.

    From there, you'll get to VBA's help.

    If you drill down far enough, you'll see that this dialog has these parms:

    xlDialogFormulaFind text, in_num, at_num, by_num,
    dir_num, match_case, match_byte

    You could seach the help for:
    BuiltIn;dialog;list;
    And get there quicker, too.

    Peter wrote:
    >
    > Hello everyone,
    >
    > Can someone let me know how to get the Find dialog on screen with the option
    > for looking in values pre-selected ?
    >
    > Thanks,
    > Peter
    > Excel 2000


    --

    Dave Peterson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1