Row Source based on a filtered list
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
|