Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Search form (XP)

    I have been asked to write this spreadsheet with a search form. I have a spreadsheet with 6 columns. It will be "read-only" so that only I can alter it.
    I want a form on the top that says "search for ....."... user types in word and I want it to search all columns.. When it finds a match it will show on another form.
    I know this can easily be done in Access but my client doesn't have access.
    I don't really know where to start using excel.
    I have no problems searching myself in excel but this will be for many people and it has to be fairly simple.
    Any suggestions to help me on the right track are much appreciated

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Search form (XP)

    Karat, an easy way is to use Excel's own Find Dialog, though this does not exactly "show on another form when it finds a match". Following is a -very- simple example:

    Sub FindInColumns()
    ActiveSheet.Columns("A:F").EntireColumn.Select ' adjust columns to what you want
    Application.Dialogs(xlDialogFormulaFind).Show
    End Sub
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Search form (XP)

    You could try using my flexfind utility from the Excel MVP page below.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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