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?