Populating dropbox depending on the value of another dropbox

Hi,

I have a code to populate 2 dropboxes. The first one contains surnames, the second forenames.

The surnames are filled like this :

Please Login or Register  to view this content.

The forenames like this :

Please Login or Register  to view this content.

Surnames has a standard value, before clicking, "Achternaam", forenames has a standard value "Voornaam".
Now, what I would like to add to my codes is when you select one of the surnames, you only get corresponding forenames. And vica versa. So when Kind1AN has a value of "Achternaam" or "" (it might be you delete the value to restart and the default is gone too) and you select a forename in Kind1VN, Kind1AN is not populated with all the surnames in column H, but only with those who have a corresponding forename available in column I. Same thing when you first choose a surname, the list with forenames is filled with only those who correspond with that surname.


Thanks in advance

The file as requested

Bump for a solution

damn this is nice ; thanks a lot bakerman2 !

Don't worry about the other option, it's not that important it was something to have if it was an easy fix

Do you have any idea why I'm having this problem :

I copied your code to the real workbook. Everything else stayed the same, just the userform code was replaced. But now, when I click my button I get an error message : runtime error "9" subscript out of range. And when I click debug it goes to my module and highlights the ingave.show line ...

got it figured out had to change "Blad1" to my sheet name thanks again, solved now ^^

OK, solved by changing all the 1's to 2's and the 2's to 3's. Dunno why, it's a type of code i can't understand but it works now ^^