(De)Populating combobox

Things moving along with my learning....was able to populate a combobox from data elsewhere in the workbook as follows:

Please Login or Register  to view this content.

Works great.

Then I decided to try and combine a couple of Subs into this one. The purpose was to eliminate some entries from the combobox after checking another set of criteria. I thought I could use "RemoveItem" much like "AddItem" in the working code. The new sub looks like this.

Please Login or Register  to view this content.

What I'm trying to do is use every instance of vItem and retrieving the status from the adjacent column. It either works...or doesn't do anything provided I leave out the If/Then statement...because the combox populates as normal.

Still new and learning...but can I use the RemoveItem argument here...or is it that I am just using it incorrectly?

I got great help from this site:
Maybe you could use Data|Validation and use dependent lists.

I'd start with Debra Dalgleish's site:
http://contextures.com/xlDataVal02.html

Hi

I had a similar problem and found that the RemoveItem argument is used in conjuntion with the ListIndex and the Index number determines what will be removed.

HTML Code: 

perhaps this link will help.

I have made a stab at amending your code as follows.

Please Login or Register  to view this content.

Originally Posted by jayers

I got great help from this site:
Maybe you could use Data|Validation and use dependent lists.

I'd start with Debra Dalgleish's site:
http://contextures.com/xlDataVal02.html

I was able to get things working another way...but thanks for the link...should be very useful in the future.

Originally Posted by solnajeff

Hi

I had a similar problem and found that the RemoveItem argument is used in conjuntion with the ListIndex and the Index number determines what will be removed.

HTML Code: 

perhaps this link will help.

I have made a stab at amending your code as follows.

Please Login or Register  to view this content.

I was unable to get this code to work right now...although it did help lead me in a new direction for possible future use.

Thanks.

Originally Posted by royUK

Try
#[code]
AircraftCrewForm.BomberNameComboBox.Clear[/code

I really thought this was the answer...but it appears that the 'Clear' argument applies to all Items currently in the list...not just that particular Item. Good to know for the future though.

Thanks.

Here is how I ended up fixing the problem. I was able to creat a Pivot Table that keeps a list of Items and their status that I do not want in the combobox.

Please Login or Register  to view this content.

Thanks again for all the replies.