Populating ComboBoxes and ListBoxes in Excel with filtered data.

[Hamsori]

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!

[opus]

You have to code to populate the ComboBox initially (using all names from Column B).
You need the check for each entry in each project wether this entry is in your ComboBox (if Yes, delete it).

And for the event when you select a new name from the combobox for a project, you need to delete that name from the combobox.

Speaking about this ComboBox, doesn't each Project have one of them, in this case you need to do the above actions for all of them.