Results 1 to 2 of 2

Thread: Populating ComboBoxes and ListBoxes in Excel with filtered data.

Threaded View

  1. Nov 9th, 2011, 06:27 AM #1
    Hamsori
    Hamsori is offline

    Thread Starter
    Lively Member
    Join Date
    Dec 2010
    Posts
    110

    Populating ComboBoxes and ListBoxes in Excel with filtered data.

    Hi all!


    I'm trying to make a simple person filtering system in Excel 2003 that basically shows to which projects different persons are assigned to.

    The idea is, that the ComboBoxes in the picture gather all names (at the moment I just used fill range) from B11:B250 that are not blank and that are not used in other projects ListBoxes...


    Lets say I'm about to add the first person to "Proj. 1". I would see all the names in that ComboBox as shown in the picture.
    After I choose "Susan" she would be inserted into the ListBox below and disappear from all the ComboBoxes.

    So the ComboBoxes need to be populated by all names from column B that are not in use in any of the project ListBoxes...


    Appreciate all hints!
    Attached Images Attached Images  
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width