View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
easy easy is offline
external usenet poster
 
Posts: 2
Default 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