Combobox help needed

[Tim C]

Is there a way to have a combobox list 2 columns using rowsource rather than an array?

Ex.

My parts spreadsheet has partnumbers in column A and description in column B.

I currently have:
Combobox1.rowsource = "'Parts'!A2:A" & Sheets("Parts").Range("A15000").End(xlUp).Row
This shows the parts list in my combobox.

Is there a modification i can do to have colum B added to the combobox so it looks like:
colA colB
HMN1056 MICROPHONE
HMN1037 DTMF MICROPHONE

I could probably put it all in an array but there a alot of part.. close to 15000... so if i could stick with rowsource.. it would probably be better.
Any ideas?

Thanks in advance.

Tim C.

 

[Andrew Poulsom]

Name your list (both columns but excluding the headings) eg MyList. On your ComboBox set the following properties:

ColumnCount 2
ColumnHeads True
RowSource MyList

Adjust the ColumnWidth property as necessary.

 

[Tim C]

Sorry Andrew... I guess i'm not understanding the name my list part.. can you clarify how to do so?

 

[Andrew Poulsom]

Select all the cells containing data in columns A and B (excluding the headings). Go to the Name box (to the left of the Formula Bar), type MyList and press Enter. Or choose Insert|Name|Define from the menu, type Mylist in the top box and click OK.

 

[Tim C]

Thanks Andrew.