Combo Drop down

Clueless in Plano · May 8th, 2002, 10:44 AM

I am trying to set up a combo drop down where the first box would be the part description, second part would be the realted cost...
How do I do that?

Thomas · May 8th, 2002, 01:01 PM

Clueless -

As I interpreted your quesiton, you need a dropdown box that will include both the part number and the cost. if this is the case, is it possible for you to add a column in your source worksheet with a concatenation of the two columns (part and cost), possibly separated by a space if needs be? For example, if the part number was in column A, and the cost was in column B, add a column to your spreadsheet with the formula :

=CONCATENATE(A1," ",B1)

and copy down. Name this new column range (ex. New_Range), and put the name into the RowSource of your combo box.

See if this helps. If not, let me know.

~Thomas

P.S. - By the way, Plano's my home town

. I'm in Dallas now, though.

Damon Ostrander · May 8th, 2002, 04:03 PM

Hi clueless,

You could also make your dropdown display the two columns by setting the ColumnCount property to 2 and setting the RowSource range to include both columns.

May 8th, 2002, 04:03 PM	#3
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	Hi clueless, You could also make your dropdown display the two columns by setting the ColumnCount property to 2 and setting the RowSource range to include both columns. __________________ Keep Excelling. Damon VBAexpert Excel Consulting (My other life: http://damonostrander.com )

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 8th, 2002, 10:44 AM	#1
Clueless in Plano New Member Join Date: May 2002 Posts: 1	I am trying to set up a combo drop down where the first box would be the part description, second part would be the realted cost... How do I do that?

May 8th, 2002, 01:01 PM	#2
Thomas Board Regular Join Date: May 2002 Location: Dallas Posts: 365	Clueless - As I interpreted your quesiton, you need a dropdown box that will include both the part number and the cost. if this is the case, is it possible for you to add a column in your source worksheet with a concatenation of the two columns (part and cost), possibly separated by a space if needs be? For example, if the part number was in column A, and the cost was in column B, add a column to your spreadsheet with the formula : =CONCATENATE(A1," ",B1) and copy down. Name this new column range (ex. New_Range), and put the name into the RowSource of your combo box. See if this helps. If not, let me know. ~Thomas P.S. - By the way, Plano's my home town . I'm in Dallas now, though.