+ Reply to Thread
Results 1 to 5 of 5

Multiple dependent ComboBoxes

  1. #1
    Forum Contributor
    Join Date
    05-12-2008
    Location
    Schleswig-Holstein, Germany
    MS-Off Ver
    2010
    Posts
    102

    Multiple dependent ComboBoxes

    Hi again,

    I惴 trying to understand how to make 3 dependent ComboBoxes...

    I悲 have coded the following example:

    3Combos.png

    3Combosb.png

    Formula: copy to clipboard
    Please Login or Register  to view this content.



    ...When I test the code, ComboBox1 and ComboBox2 work fine but ComboBox3 never display the entries...Why?


    Thanks in advance,
    Ruben

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Multiple dependet ComboBoxes

    In your code for ComboBox2 you are adding more items to ComboBox2 instead of adding to ComboBox3.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    05-12-2008
    Location
    Schleswig-Holstein, Germany
    MS-Off Ver
    2010
    Posts
    102

    Re: Multiple dependent ComboBoxes

    Thanks for the hint

    I扉e changed the code but instead of...

    A.2.1
    A.2.2
    A.2.3
    A.2.4

    ...it should be displayed...

    B.2.1
    B.2.2
    B.2.3
    B.2.4
    Attached Images Attached Images
    Last edited by buhnen; 05-26-2016 at 02:40 AM.

  4. #4
    Forum Contributor
    Join Date
    05-12-2008
    Location
    Schleswig-Holstein, Germany
    MS-Off Ver
    2010
    Posts
    102

    Re: Multiple dependet ComboBoxes

    I扉e tried the following code but it doesn't work either

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    05-12-2008
    Location
    Schleswig-Holstein, Germany
    MS-Off Ver
    2010
    Posts
    102

    Re: Multiple dependent ComboBoxes

    So, I扉e uploaded the code....
    Attached Files Attached Files

+ 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] Dependent comboboxes on userform
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 02-17-2016, 11:29 PM
  2. VBA Dependent Comboboxes from large data set
    By lxsscott in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-10-2013, 03:47 PM
  3. Two comboBoxes dependent on one another (userform)
    By fionamb83 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-20-2013, 05:18 AM
  4. [SOLVED] Dependent comboboxes
    By ObiWanBaloney in forum Excel General
    Replies: 6
    Last Post: 06-04-2012, 08:40 PM
  5. dependent comboboxes
    By humboldtguy in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 05-14-2010, 10:40 PM
  6. UserForms & dependent ComboBoxes?
    By hit_king51 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-11-2010, 09:30 PM
  7. 3 dynamic comboboxes, 2nd dependent on 1st and 3rd dependant on 2nd in VBA
    By begilhang in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-09-2010, 05:15 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