Dropdown list with 2 columns

[2vao]

Hello,

I have a list of values in one column and a list of description of each
value in the adjacent column. Is it possible to have a dropdown list with
both columns but only the value of the 1st column is posted in the cell after
selection ? I tried merging but did not work.

Many thanks.

 

[Max]

One possible alternative to achieve it
would be to use a combo box from control toolbox

Take a look at this sample from my archives:
http://savefile.com/files/221672
Combo box from control toolbox toolbar_Example2

Success? Celebrate it, click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik

 

[2vao]

Thank you very much Max, that worked.

One possible alternative to achieve it
would be to use a combo box from control toolbox

Take a look at this sample from my archives:
http://savefile.com/files/221672
Combo box from control toolbox toolbar_Example2

Success? Celebrate it, click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik

 

[Max]

Welcome, thanks for feeding back.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik