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 "view" 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

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'Data Validation Change'

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

"Bruce" wrote in message
...
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 "view" or
how
it was done. More importantly, I don't remember who did it.