+ Reply to Thread
Results 1 to 3 of 3

ActiveX combobox datalist dependant on previous combobox selections

  1. #1
    Registered User
    Join Date
    10-02-2014
    Location
    Bristol
    MS-Off Ver
    2010
    Posts
    2

    Post ActiveX combobox datalist dependant on previous combobox selections

    Hi,

    I'm new to VBA so please bear with me. Basically I have 8 combobox's with the same datalist. What I would like to do is remove each item selected from the available items in the next combobox datalist (so that an item can only be selected once). So if the datalist was:

    Asbestos
    ATW
    BRK
    CAR
    PLM

    and the Combo1.Value = Asbestos then the datalist for Combo2 would be:

    ATW
    BRK
    CAR
    PLM

    and Combo2.value = BRK then the datalist for Combo3 would be:

    ATW
    CAR
    PLM

    and so on....

    There are 64 items in the list.

    Can anyone help?

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,173

    Re: ActiveX combobox datalist dependant on previous combobox selections

    after update of the combo
    run macro to add all the items from the SRC to the TARGET combo, EXCEPT what was picked.

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    10-02-2014
    Location
    Bristol
    MS-Off Ver
    2010
    Posts
    2

    Re: ActiveX combobox datalist dependant on previous combobox selections

    Hi and thanks for your reply.

    I've had a go at this but with no success. I have combo1 listfillrange set but not on the other 7 combos. When I run this code for the first two combos (as a test) combo2 has no dropdown list. If I reference the listfillrange for combo2 I get 'runtime error 70' because you can't use additem when this is specified.

    Any ideas?

+ 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. Replies: 1
    Last Post: 11-07-2014, 01:21 PM
  2. [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
  3. populate 4 combobox based on dependant combobox
    By roninn75 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-06-2013, 06:09 AM
  4. [SOLVED] Changeing Combobox Colors based on other combobox selections
    By dagindi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-15-2012, 11:42 AM
  5. Code to reset combobox dependant on another combobox
    By j.farr3ll in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-08-2011, 08:21 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1