+ Reply to Thread
Results 1 to 4 of 4

Autofilter or Search as you type in ComboBox

  1. 11-09-2017, 08:59 PM #1
    Mnet
    Mnet is offline
    Registered User
    Join Date
    11-16-2014
    Location
    America
    MS-Off Ver
    2016
    Posts
    43

    Question Autofilter or Search as you type in ComboBox

    Dear Excel users, I have a problem to auto filter or search a predefined list in a combo-box. I have two comboboxes on a Userform - the first one calls up job numbers (Reg5) and the second one calls up activities (Reg6) that is related to whatever is selected in Reg5. Because the list in Reg 5 is massive I want to be able to filter or search the list as I type in a text or number. It must ALSO allow me to type and search!! Any Suggestions? All help will be greatly appreciated !!!!!

    Please Login or Register  to view this content.
    Please Note I have placed the same question on Mr Excel but regrettably no solution or replies!!
    https://www.mrexcel.com/forum/excel-...-combobox.html
    Last edited by Mnet; 11-09-2017 at 09:03 PM.
    Reply With QuoteRegister To Reply
  2. 11-09-2017, 09:54 PM #2
    mjr veverka
    mjr veverka is offline
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,151

    Re: Autofilter or Search as you type in ComboBox

    This means that they are dependent lists - "the data from one column is related to the data in the second column", as you wrote above.
    Quote Originally Posted by Mnet View Post
    ... that is related to whatever is selected in Reg5 ...
    Look at this and try adjusting it to your requirements.

    Ps: This is only a dependent list, the search is direct based on the existing entries, not the approximate entries.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 11-12-2017, 09:00 PM #3
    Mnet
    Mnet is offline
    Registered User
    Join Date
    11-16-2014
    Location
    America
    MS-Off Ver
    2016
    Posts
    43

    Re: Autofilter or Search as you type in ComboBox

    Dear Porucha, thank you but it is not what I'm looking for - If I select a Job number (Reg5) it automatically filter the list to show the applicable Activities in Reg6 - So it is working perfectly. What I'm asking is that when I type a jobnumber in Reg5 it automatically filter Reg5 as I type to only show jobnumbers e.g. 1582350 and not the rest - alternatively I will also be happy if I can search Reg5 by typing in a number and it come up with that number....Any Suggestions????
    Reply With QuoteRegister To Reply
  4. 11-12-2017, 09:16 PM #4
    mikerickson
    mikerickson is offline
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Autofilter or Search as you type in ComboBox

    The file in the link doesn't do what you want, but the filtering routine can be adapted to your needs.
    https://www.ozgrid.com/forum/forum/t...ering-combobox
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Search as you type Combobox Excel Userform
    By RJ1969 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-13-2017, 02:51 PM
  2. AutoFilter as you Type
    By XL4U in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-18-2015, 10:05 AM
  3. Help: Adding additional search features ComboBox/DropDownList to search specific columns
    By khhoa in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-02-2014, 05:17 PM
  4. [SOLVED] userform search button remove search only when i type
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-08-2014, 02:32 AM
  5. ComboBox & Autofilter
    By jsneak in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2014, 02:53 PM
  6. How to work filters in combobox when i type some some data in combobox
    By suresh mongam in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-29-2012, 04:50 AM
  7. Combobox-listbox multi-type search
    By greekboyuk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-01-2011, 03:47 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1