Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dropdown list with 2 columns
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dropdown list with 2 columns
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" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dropdown list with 2 columns
Thank you very much Max, that worked.
"Max" wrote: 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" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dropdown list with 2 columns
Welcome, thanks for feeding back.
-- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "2vao" wrote in message ... Thank you very much Max, that worked. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dropdown list determined by another dropdown list | Excel Discussion (Misc queries) | |||
Excell Dropdown List. Display alternate text than found in list. | Excel Discussion (Misc queries) | |||
Dropdown List - list item endings not visible if column too narrow | Excel Discussion (Misc queries) | |||
result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions |