+ Reply to Thread
Results 1 to 13 of 13

Search While Typing

  1. #1
    Registered User
    Join Date
    03-30-2014
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    63

    Search While Typing

    Hi Gurus

    Is it possible to have a cell that narrows a search down while you type?

    For example in my attached document, in column C i have a validation for each cell to list all the products from another sheet (Product List). But it takes to long to search, even in alphabetical order. I want to type in "crumbed", then all the products which includes the words crumbed, must become visible to choose from.

    Colom A the same, with supplier names from the INFO Sheet

    Will this be possible for each cell? (Column A and C - the yellow Columns)

    Thank you SOOOOOOOOOOO much
    Attached Files Attached Files

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Search While Typing

    Hi, please see the links below for searchable dropdowns:
    https://trumpexcel.com/excel-drop-do...h-suggestions/
    https://stackoverflow.com/questions/...s-autocomplete
    Click the * to say thanks.

  3. #3
    Valued Forum Contributor
    Join Date
    02-02-2016
    Location
    Indonesia
    MS-Off Ver
    Office 365
    Posts
    995

    Re: Search While Typing

    Another method:
    Use a combobox (put it above the data in the column in question), it will show the list & narrow down as you type.
    Here's an example:
    Let me know if you're interested.
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor
    Join Date
    02-02-2016
    Location
    Indonesia
    MS-Off Ver
    Office 365
    Posts
    995

    Re: Search While Typing

    Here's a screenshot of the above combobox:

    combo search.jpg

  5. #5
    Registered User
    Join Date
    03-30-2014
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    63

    Re: Search While Typing

    Thanks PaulM100 - very insightful videos, thanks.

  6. #6
    Registered User
    Join Date
    03-30-2014
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    63

    Re: Search While Typing

    Hi Akuini, Thank you. this is close to what I need. I will try and see how I can do this in my spreadsheet. Thank you. I would like every cell to do the search and select like your combo box. but this might also work.
    Thanks

  7. #7
    Registered User
    Join Date
    03-30-2014
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    63

    Re: Search While Typing

    Quote Originally Posted by Akuini View Post
    Another method:
    Use a combobox (put it above the data in the column in question), it will show the list & narrow down as you type.
    Here's an example:
    Let me know if you're interested.
    Hi Akuini

    Is it possible to help met with the HOW TO? As i keep doing something wrong and does not want to work on my Column A and C

    Column A gets the info from the INFO tab
    Column C get the info from the Product list Tab

    THanks (Shy face)

  8. #8
    Valued Forum Contributor
    Join Date
    02-02-2016
    Location
    Indonesia
    MS-Off Ver
    Office 365
    Posts
    995

    Re: Search While Typing

    Quote Originally Posted by ronettes View Post
    I would like every cell to do the search and select like your combo box.
    You mean without using combobox, every cell can do the search and select?
    I don't know how to do that. Maybe someone else here could help.

  9. #9
    Registered User
    Join Date
    03-30-2014
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    63

    Re: Search While Typing

    Quote Originally Posted by Akuini View Post
    You mean without using combobox, every cell can do the search and select?
    I don't know how to do that. Maybe someone else here could help.
    PLease help me with your way

  10. #10
    Forum Expert Roel Jongman's Avatar
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    1,482

    Re: Search While Typing

    Hi ronnetes,

    Please find attached a sample workbook that uses a combobox but also make that combobox appear in the active cell.

    I'm sure some "reversed engenineering" helps you find the workings and re-build it in your sheet.
    Attached Files Attached Files

  11. #11
    Valued Forum Contributor
    Join Date
    02-02-2016
    Location
    Indonesia
    MS-Off Ver
    Office 365
    Posts
    995

    Re: Search While Typing

    Quote Originally Posted by ronettes View Post
    Hi Akuini

    Is it possible to help met with the HOW TO? As i keep doing something wrong and does not want to work on my Column A and C

    Column A gets the info from the INFO tab
    Column C get the info from the Product list Tab

    THanks (Shy face)
    Ok try this:
    If you decide to use this approach & need more help to implement it, just let me know.
    Attached Files Attached Files

  12. #12
    Registered User
    Join Date
    03-30-2014
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    63

    Re: Search While Typing

    Quote Originally Posted by Akuini View Post
    Ok try this:
    If you decide to use this approach & need more help to implement it, just let me know.
    THANK YOU SO MUCH. I think this might make my work much more easier with record keeping rather than typing everything out. THANKS

  13. #13
    Valued Forum Contributor
    Join Date
    02-02-2016
    Location
    Indonesia
    MS-Off Ver
    Office 365
    Posts
    995

    Re: Search While Typing

    Quote Originally Posted by ronettes View Post
    THANK YOU SO MUCH. I think this might make my work much more easier with record keeping rather than typing everything out. THANKS
    You're welcome, glad to help, & thanks for the feedback.

    Note: I limited the area you can fill in using the combobox value to row 10000, you may change that in this part:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] UserForm Search - Find the product when typing the ID
    By DanPa in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-16-2017, 02:12 AM
  2. Replies: 0
    Last Post: 02-07-2016, 07:47 AM
  3. Filter columns by typing text in a search box?
    By getmemickey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-03-2016, 06:41 PM
  4. search typing mistaken number
    By sanju2323 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-03-2016, 11:29 AM
  5. VBA Code - Search text & search number & search qty and result - Urgent Please
    By naresh73 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-15-2014, 10:51 AM
  6. Search by typing in first letter into dropdown box
    By kathhear in forum Excel General
    Replies: 2
    Last Post: 03-15-2013, 03:46 AM
  7. [SOLVED] Speed Search in pick list by typing only first few letters
    By Shrikant in forum Excel General
    Replies: 2
    Last Post: 08-25-2005, 09:05 AM

Tags for this Thread

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