Results 1 to 4 of 4

Thread: Find Dialog Box

  1. #1
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    I have users that do a lot of finding in a selected range. Is itpossible to create a macro that opens the find dialog box and sits and waits for the user to type in the criteria?

    Thanks for any help provided!

    Itconc

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Yes:

    Code:
    Sub FindIt()
      CommandBars.FindControl(ID:=1849).Execute
    End Sub

  3. #3
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='780353' date='17-Jun-2009 14:14']Yes:

    Code:
    Sub FindIt()
      CommandBars.FindControl(ID:=1849).Execute
    End Sub
    [/quote]

  4. #4
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thank you

Posting Permissions

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