Combobox list 3 column

**vlady** · 07-01-2013, 11:13 PM

create a named range with the 3 columns--->PARTID,TYPE,PARTDESC selected
your named range say "ALL" refers to: =LookupLists!$E$2:$G$8

in the properties of the combobox look for the "Column Count" change that to "3"
then in the Listfillrange use the named range from the 3 columns ->
Listfillrange: ALL

**johnreid7477** · 07-01-2013, 11:41 PM

Originally Posted by vlady

create a named range with the 3 columns--->PARTID,TYPE,PARTDESC selected
your named range say "ALL" refers to: =LookupLists!$E$2:$G$8

in the properties of the combobox look for the "Column Count" change that to "3"
then in the Listfillrange use the named range from the 3 columns ->
Listfillrange: ALL

Hi Vlady,

Thanks for support, i'm do until until step 2 ( "Column Count" change that to "3"), but i'm newbie for this VBA need help where's listfillrange .... if i not wrong for this code ..

Me.cboPart.Clear
For Each cPart In ws.Range("PartIDList")
  With Me.cboPart
    .AddItem cPart.Value
    .List(.ListCount - 1, 1) = cPart.Offset(0, 1).Value
  End With
Next cPart

or still properties combobox but no see listfillrange ...

Thansk - John