Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Mar 2002
    Location
    Sherbrooke, Qc, Canada, Quebec, Canada
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Searches in Excel with VBA (VBA/Excel (all))

    Hello
    I have a worksheet of about 4000 street names and directions to get to these streets.

    I'm looking for a way to be able to search the worksheet in the following way: lets say we're looking for "Conseil" street, when I first type a "C" I will get all the street names that start with a "C", next when I type an "o" I will then get all the streets that start with "Co" and so on, so that my list gets narrowed with every letter that I type.
    Thanks in advance

  2. #2
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts

    Re: Searches in Excel with VBA (VBA/Excel (all))

    <P ID="edit" class=small>(Edited by Gary Frieder on 18-Dec-02 21:37. )</P>C-S,

    See the attached workbook - run the "ShowTheForm" sub to display the userform.
    To make things easier, I've already sorted the address entries in the worksheet.

    Gary

    Note: For some reason, this doesn't want to run when opened within IE; I'd suggest saving it to your own PC and running it there.
    Attached Files Attached Files

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

    Re: Searches in Excel with VBA (VBA/Excel (all))

    You might consider downloading my Flexfind.zip from the Excel MVP page as stated 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
  •