Just loop through the range and where the entry in the second column equals
the selected type, use additem to add the data to the second combobox.

--
Regards,
Tom Ogilvy

"easy" wrote in message
...
Hi first post here.
I have a problem creating a row source for a combo box.
I have a worksheet that has 3 columns:
"Code", "Type", "Description"

On my form there are 2 combo boxes.
Combo box selects the "Type"
What I want the second combo box to do is create its list from the records
on the worksheet where the rcords are of the "type" selected by the first
box.
(Same as AuotFilter works)
Any help greatly appreciated, but take it easy i'm a newbie to vba

TIA