Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generate a value from user selection in list box.
I have created a dropdown list box that allows the user to select only one of
the items contained in it. How do I generate a corresponding value in another cell that depends on the user selection in the list box? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generate a value from user selection in list box.
Is it a Data Validation drop-down?
If so, maybe the info at Debra Daleish's site can help. http://www.contextures.on.ca/xlDataVal02.html Gord Dibben MS Excel MVP On Fri, 8 Sep 2006 09:51:02 -0700, Sol wrote: I have created a dropdown list box that allows the user to select only one of the items contained in it. How do I generate a corresponding value in another cell that depends on the user selection in the list box? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generate a value from user selection in list box.
Gord read your question as looking for *another list* to be the result of a
choice from the first list. If you're just looking for a *single* data value to be the result of a choice from that first list, then try this link from the same web site, but from a different page on Vlookup, where you'll need to set up a datalist to contain your choices: http://www.contextures.com/xlFunctions02.html -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Is it a Data Validation drop-down? If so, maybe the info at Debra Daleish's site can help. http://www.contextures.on.ca/xlDataVal02.html Gord Dibben MS Excel MVP On Fri, 8 Sep 2006 09:51:02 -0700, Sol wrote: I have created a dropdown list box that allows the user to select only one of the items contained in it. How do I generate a corresponding value in another cell that depends on the user selection in the list box? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
validation list - filter based on selection | Excel Worksheet Functions | |||
Allow selection of multiple values in dropdown list in excel | Excel Discussion (Misc queries) | |||
List box - setting default selection | Excel Discussion (Misc queries) | |||
limit cell list selection based on the selection of another list | Excel Worksheet Functions | |||
Data Validation list selection question | Excel Worksheet Functions |