+ Reply to Thread
Results 1 to 13 of 13

To make a Dynamic Search DropDownList in UserForm.ComboBox

  1. #1
    Forum Contributor
    Join Date
    01-13-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2010 and 2019, but only 2019 to test if my sheets works!
    Posts
    149

    To make a Dynamic Search DropDownList in UserForm.ComboBox

    Hi Forum.

    First sorry for my English, but I hope you understand anyway

    I found a YouTube, how to make a Dynamic Search DropDownList in a ComboBox, but the ComboBox is placed in the Sheet and not in a Userform.
    Link to the YouTube is in the attached file.

    As you can see in the attached too, I both made an in Sheet ComboBox and a Userform ComboBox and both with separate codes.
    The in Sheet Dynamic Search DropDownList works.


    The Userform ComboBox
    1) Is it possible to make the same Dynamic Search DropDownList in the Userform ComboBox ?

    When a name is selected, it list data attached to the name, in some TextBoxes.
    2) Is it possible to combine this feature together with the Dynamic Search DropDownList ?


    Because I'm not very good in VBA coding, I would appreciate if you could cut the explanation out in peaces or even better, make the code in the attached file and send it back to me.

    Thank you in advance.

    Ib
    Attached Files Attached Files
    Last edited by gnaske; 09-07-2015 at 05:29 AM.

  2. #2
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: To make a Dynamic Search DropDownList in UserForm.ComboBox

    See Sheet "Ark2":-
    Attached Files Attached Files

  3. #3
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: To make a Dynamic Search DropDownList in UserForm.ComboBox

    @Mick, did you test that?

  4. #4
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: To make a Dynamic Search DropDownList in UserForm.ComboBox

    Just downloaded my file and appears to be working OK , Have I missed something?? (I'm quite good at that )

  5. #5
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: To make a Dynamic Search DropDownList in UserForm.ComboBox

    Hehe, that's normally my line.

    Try typing in the combobox in the form

  6. #6
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: To make a Dynamic Search DropDownList in UserForm.ComboBox

    Kyle, I thought the idea was to select a name, but I get your point !!
    Gnaske, please modify the Combobox code as below :-
    Please Login or Register  to view this content.
    I'm not totally sure this is what you want , but it's a Start.
    Regrds Mick

  7. #7
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: To make a Dynamic Search DropDownList in UserForm.ComboBox

    I *think* he wants to type in the box to filter the list of names

  8. #8
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: To make a Dynamic Search DropDownList in UserForm.ComboBox

    I've watched the video, and am now feel rather tired !!!!
    Perhaps this when code is run from sheet "Ark1":-
    Please Login or Register  to view this content.

  9. #9
    Forum Contributor
    Join Date
    01-13-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2010 and 2019, but only 2019 to test if my sheets works!
    Posts
    149

    Re: To make a Dynamic Search DropDownList in UserForm.ComboBox

    Hi Mike and Kyle.

    First thank you for answering back.

    When something is typed in the, InSheet Combobox as e.g. the letter C, a dynamic search will show all the names containing the letter C.
    - In column J, all the names containing the letter C, will have the number 1 - Everybody else the number 0
    - In column K you can see there is 8 names containing the letter C.
    - Column L is the dynamic part and all the names is listed in the first 8 cells from the top and this is what you see in the InSheet Combobox too.

    If you after the C type the letter L, the search will now reduce the search to two possible names, containing those two letters - Claus Hansen, Claus Rydahl.
    - In column K you can see the names is present in row 2 and 18.
    - And in column L, the names is listed dynamic from the top.


    In the menu, Formula - Name Management, you use a part of the code from M2 (With red below) in a new Name Management and call it InSheetDropDownList
    Please Login or Register  to view this content.

    And then you use the Name Management InSheetDropDownList in the InSheet ComboBox
    Please Login or Register  to view this content.

    As you can see I had copied the codes from the columns J:M (with green) to the columns O:R (with yellow).
    And then I use the O:R codes in the InUserform ComboBox.

    I also made a new Name Management named InUserFormDropDownList and then I use this Name Management in the InUserform ComboBox too.
    I do this to split the two CombomBoxes from each other in this test sheet.


    My real problem is:
    1) I miss some settings in the Userform Combobox properties, compared, which had been used in the InSheet Combobox properties.

    2) I can't define the Userform Combobox to use the Name Management InUserformDropDownList

    The Bug is the ListFillRange, (with red below) and I need to change that code for use in a Userform ComboBox.
    Please Login or Register  to view this content.

    I had searched the net and the only codes i can find for a Userform ComboBox, referring to the Name Management, is Excel 2003/2007 codes and they doesn't work in my 2010 Excel.

    I attached a new Test Sheet named B in the end and in this you can test the InUserformComboBox to see the Bug.

    I really appreciate you help.
    Thank you.

    Ib
    Attached Files Attached Files

  10. #10
    Registered User
    Join Date
    04-21-2015
    Location
    Köln,Germany
    MS-Off Ver
    2010
    Posts
    40

    Re: To make a Dynamic Search DropDownList in UserForm.ComboBox

    Hello,

    I am trying to create a filter with combobox, for example if I select the name ”John” in the fist combobox, then all the person and information with the name John are presented in the Listbox(Name ,Age, Length) and if I select the first name the result in listbox should be filtered etc..

    Your help would be greatly appreciated.

    Thanks
    Name: exceltable.JPG Views: 9 Size: 119.7 KBName: userform.JPG Views: 9 Size: 33.2 KB

  11. #11
    Registered User
    Join Date
    04-21-2015
    Location
    Köln,Germany
    MS-Off Ver
    2010
    Posts
    40

    Re: To make a Dynamic Search DropDownList in UserForm.ComboBox

    Hello,

    I am trying to create a filter with combobox, for example if I select the name ”John” in the fist combobox, then all the person and information with the name John are presented in the Listbox(Name ,Age, Length) and if I select the first name the result in listbox should be filtered etc..

    Your help would be greatly appreciated.

    Thankstable.pnguserform.png

  12. #12
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: To make a Dynamic Search DropDownList in UserForm.ComboBox

    Hi Hilfesucher

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

  13. #13
    Registered User
    Join Date
    04-21-2015
    Location
    Köln,Germany
    MS-Off Ver
    2010
    Posts
    40

    Re: To make a Dynamic Search DropDownList in UserForm.ComboBox

    Hi Bernie,

    Thanks for your help.
    I keep getting errors when I select the name for example”John” in the first combobox


    Thanks again
    Filtercombobox.xlsmFiltercombobox.xlsm

+ 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. can i make it so i can also type number into combobox in userform
    By justlearning123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-02-2015, 10:02 PM
  2. Replies: 4
    Last Post: 12-02-2014, 05:17 PM
  3. [SOLVED] Make combobox list options dependant on selection in another combobox within a userform
    By Vladimir_Dobvchenko in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-23-2013, 05:30 AM
  4. [SOLVED] Dynamic combobox userform
    By Sleepyshy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-20-2012, 11:41 AM
  5. Replies: 1
    Last Post: 08-14-2010, 02:53 AM
  6. Populate a combobox in a userform with a dynamic range.
    By BigBas in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-23-2007, 01:12 PM

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