+ Reply to Thread
Results 1 to 9 of 9

Combobox filter while typing is confused with other combobox list

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

    Combobox filter while typing is confused with other combobox list

    Hi Gurus

    I Need some help. I have 2 combo boxes in my Template. The top one Drops down the PRODUCT LIST, the second one drops down from the PACKAGING LIST. Then while you type, it should filter to what you are typing. But at the bottom one (Combo Box 3) When you press the arrow, it shows the list as on the packaging list, but if you type a letter, it filters the list from the PRODUCT LIST.

    Why is that - I don't see the error in my VBA?? All my formulas as coding is done in the TEMPLATE tab, which gets copied as soon as a new recipe is made.

    Example:

    At the bottom one when pressed on the arrow - you see a few packaging called FOMO... But tipe FOMO, you dont get the list of FOMO packaging, when typing F it gives the products..



    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021
    Posts
    7,546

    Re: Combobox filter while typing is confused with other combobox list

    Hope I can understand what you're asking, I'll download and check the file to see if I understand and interpret your question correctly
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    7,673

    Re: Combobox filter while typing is confused with other combobox list

    You're calling the wrong routine. You have:

    Please Login or Register  to view this content.
    but it should be:

    Please Login or Register  to view this content.
    Rory

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

    Re: Combobox filter while typing is confused with other combobox list

    Quote Originally Posted by rorya View Post
    you're calling the wrong routine. You have:

    Please Login or Register  to view this content.
    but it should be:

    Please Login or Register  to view this content.

    (face palm) how did i miss that!!

    Thanks so much lol!!

  5. #5
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    7,673

    Re: Combobox filter while typing is confused with other combobox list

    Since the code is largely the same other than the sheet and combobox, you should really just have one routine and pass both those things as arguments.

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

    Re: Combobox filter while typing is confused with other combobox list

    Quote Originally Posted by rorya View Post
    Since the code is largely the same other than the sheet and combobox, you should really just have one routine and pass both those things as arguments.
    Please explain - Not sure I understand.

    LOL

  7. #7
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021
    Posts
    7,546

    Re: Combobox filter while typing is confused with other combobox list

    If you compile the VBA code there are quite a few errors especially references
    What @rorya is saying is that when coding you should limit repetitive routines to the minimum and use parameters to address different values, this makes it manageable, but that will come with experience and programming routines.

  8. #8
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    7,673

    Re: Combobox filter while typing is confused with other combobox list

    Just use this:
    Please Login or Register  to view this content.
    and then amend your Call statements to pass the relevant worksheet as well:

    Please Login or Register  to view this content.

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

    Re: Combobox filter while typing is confused with other combobox list

    Quote Originally Posted by rorya View Post
    Just use this:
    Please Login or Register  to view this content.
    and then amend your Call statements to pass the relevant worksheet as well:

    Please Login or Register  to view this content.
    COOL!! Thanks - Makes sense - I will definitely try this. Thanks

    Marking thread as SOLVED

+ 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. VBA: use external file as DB and combobox for drop down list selection: confused and lost
    By scott micklo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-22-2016, 11:59 AM
  2. [SOLVED] Userform: Change Combobox list based on a second ComboBox selection
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-11-2016, 03:45 PM
  3. [SOLVED] Change next ComboBox list based on previous ComboBox selection
    By SteveTheFish in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-26-2015, 11:23 PM
  4. [SOLVED] Filter Combobox base on selection from previous combobox
    By ciapul12 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-18-2013, 07:25 PM
  5. Making a FormControl ComboBox's list depend on the value of another ComboBox's Reference
    By dpsciarrino in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-24-2013, 11:52 PM
  6. [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
  7. Combobox Populating via a list or directly typing
    By nighttrainrex in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-30-2011, 05:03 PM

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