combo box -> value ?

555466 · Feb 25, 2004

Hello

how to get a value by using combo box ?

Example:

ID Number
A 10
B 40
C 100
D 200

i want the combo box to show both values (ID and Number) and after
selection,
set the Number -value to certain cell ?

How to ddo it ?

Frank Kabel · Feb 25, 2004

Hi
one way using data validation. See the following site for an example
sheet:
http://www.contextures.com/excelfiles.html#DataVal
http://www.contextures.com/DataValNameID.xls

555466 · Feb 25, 2004

Frank,

thanks for very prompt reply. This solved my problem.

555466 · Feb 25, 2004

Might be a stupid questions, but anyway, how can I add more rows (more
products), which would show also in combo box ?

Frank Kabel · Feb 25, 2004

Hi
just make the source list larger or use a defined name which adapts
automatically if you add more products
see
http://www.contextures.com/xlNames01.html#Dynamic

combo box -> value ?

555466

Frank Kabel

555466

555466

Frank Kabel