Hello NG,

I have a worksheet with a lot of columns. One of these are FirstName
and Lastname. One row is one buying. I want to create a form with two
comboboxes. In the first are all Lastnames written. (I got them with
the AdvancedFilter Funktion.) If the user selects one Lastname the
second cbo should be filled with Firstnames that matches to the
Lastname.

Doese someone know how to handle this?


Best wishes

Peter

loop through the list of lastnames and if it matches, use additem to add it
to the list of the second combobox.

for each cell in Range("LastNames")
if cell.Value = cbo1.Value then
cbo2.Additem cell.offset(0,-1).Text
end if
Next

--
Regards,
Tom Ogilvy


wrote in message
oups.com...
Hello NG,

I have a worksheet with a lot of columns. One of these are FirstName
and Lastname. One row is one buying. I want to create a form with two
comboboxes. In the first are all Lastnames written. (I got them with
the AdvancedFilter Funktion.) If the user selects one Lastname the
second cbo should be filled with Firstnames that matches to the
Lastname.

Doese someone know how to handle this?


Best wishes

Peter

Thanks Tom :-)