combobox2 change --> combobox1 change

[mabulco]

I have two columns with ids (column 1 and column 3). The ids in Column 3 aren't unique (but are in the combobox(2)). What I want is that when I pick an ID in combobox2, only the ids of column1 on the same row(s) as these id(s) stay in the combox1. I can't get it to work. Even not with google

mabulco

Please Login or Register  to view this content.

[Norie]

How isn't it working?

The only thing wrong, and it won't affect anything, is the unneeded For Each loop.

[mabulco]

I remove the For Each loop. I should have been clearer about the problem I'm experiencing. The problem is, that absolutely nothing happens. Combobox1 stays empty. Could it be that I didnt get the range straight? ie. not the content of column1?

[Norie]

If the IDs you want to match with what's selected in combobox2 are in column A (1) then the If should be like this.

Please Login or Register  to view this content.

I think that's right anyway.

Perhaps uploading a sample workbook might make things clearer.

[mabulco]

test.xlsmHere is my workbook. In the workbook: if i select 1 in combobox2. 1, 2, 3 (a1, a2, a3) should only be visible in combobox1.

[Norie]

You had things the right way round in the first code, think I was confused because the textboxes are sort of the wrong way round, you would normally be populating the second combobox based on the first.

But anyway, try this.

Please Login or Register  to view this content.