View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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?