Thanks. But I guess I'm not smart enough to figure that out. Do you have an
easier explanation?

"Debra Dalgleish" wrote:

You can do this with programming. There's a sample file he

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

Under data validation, look for 'DV0005 - Data Validation "Columns"'

bonhill66 wrote:
I want to creat a dropdown menu that will display in the cell on part of what
is shown on the dropdown menu. For example, if the dropdown menu item is
"A101 - plan & prepare for", and want the cell to display "A101". Is that
even possible? If so, how?
Thanks.


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com