Combobox list 3 column

[johnreid7477]

Hi All,

Please help how to view combobox list until 3 Column .

In Example
Combobox PartID : (PARTID,TYPE)

Need Result
Combobox PartID : (PARTID,TYPE,PARTDESC)


Thanks - John

[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

[johnreid7477]

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 ..

Please Login or Register  to view this content.

or still properties combobox but no see listfillrange ...

Thansk - John

[johnreid7477]

Please explain for more detail if i make stupid mistake

[vlady]

first offset returns "Type"

Please Login or Register  to view this content.

add another offset for the "Part Descr."

Please Login or Register  to view this content.

[johnreid7477]

first offset returns "Type"
.List(.ListCount - 1, 1) = cPart.Offset(0, 1).Value

add another offset for the "Part Descr."

.List(.ListCount - 1, 2) = cPart.Offset(0, 2).Value

Hi Vlady,

Do you mean be like this

Please Login or Register  to view this content.

I'm test and work like charm.

Thank you very much - John

[vlady]

Nice to hear that.
Your welcome and sorry for the delay.. have visitors.