+ Reply to Thread
Results 1 to 8 of 8

Multiple dynamic Comboboxes in UserForm

  1. #1
    Registered User
    Join Date
    11-10-2011
    Location
    Norway
    MS-Off Ver
    Excel 2003
    Posts
    16

    Multiple dynamic Comboboxes in UserForm

    Please see the attached document.
    I have this huge database of items that I want easy access to.
    My idea is a Userform with the option of selecting a few categories.
    The more categories selected, the less products will show in the last combobox.

    If "Blue" is selected under Category1, products 1-10 will show in the last combobox, and only "Green" and "Orange" will show in the Category2-combobox.

    Book1.xls

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: Multiple dynamic Comboboxes in UserForm

    Hi
    You want the products in the last combo box when the "Insert Product" is clicked right?
    Click *, if my suggestion helps you. Have a good day!!

  3. #3
    Registered User
    Join Date
    11-10-2011
    Location
    Norway
    MS-Off Ver
    Excel 2003
    Posts
    16

    Re: Multiple dynamic Comboboxes in UserForm

    No, when I click "Insert Product" the userform inserts the desired product somewhere else, but that's not really t

  4. #4
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: Multiple dynamic Comboboxes in UserForm

    What are the conditions for combo3 and combo4?

  5. #5
    Registered User
    Join Date
    11-10-2011
    Location
    Norway
    MS-Off Ver
    Excel 2003
    Posts
    16

    Re: Multiple dynamic Comboboxes in UserForm

    Each combobox relates to the four "category"-columns

  6. #6
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: Multiple dynamic Comboboxes in UserForm

    I m uploading the file pls check it. I have got it do what you had specified.. Any probs pls do inform...

    Book1.xlsm

  7. #7
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: Multiple dynamic Comboboxes in UserForm

    Try this...

    Book1.xlsm

    Regards...

  8. #8
    Registered User
    Join Date
    11-10-2011
    Location
    Norway
    MS-Off Ver
    Excel 2003
    Posts
    16

    Re: Multiple dynamic Comboboxes in UserForm

    With some modifications i got this to work, thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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