software

I've seen someone use a list, but when you selected something from the list,
another value went in the cell.

For example, the list may contain a name John Smith, but when you select
that, only JS is put into the cell. I don't know if this is a quot;viewquot; or how
it was done. More importantly, I don't remember who did it.

You can do this with programming. There's an example he

www.contextures.com/excelfiles.html

Under Data Validation, look for 'Data Validation Change'

--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html

quot;Brucequot; gt; wrote in message
...
gt; I've seen someone use a list, but when you selected something from the
list,
gt; another value went in the cell.
gt;
gt; For example, the list may contain a name John Smith, but when you select
gt; that, only JS is put into the cell. I don't know if this is a quot;viewquot; or
how
gt; it was done. More importantly, I don't remember who did it.