There's a sample workbook on my web site that shows a product name and
code in the Data Validation dropdown list. After an item is selected,
the cell shows only the product name. You could adapt this to your
workbook.

On the following page:

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

Under Data Validation, look for "Data Validation Columns"


wrote:
Hi,
I'm new to VBA. I previously use Data/Validation to set up a drop-down
list for one of the cells. For example, I would go to Data/Validation
and choose List under "Allow" and specified "H,M,L" under "Source".

I need the cell to have a value of H, M, or L but our user would like
to see the drop down list as:
H - HIGH
M - MEDIUM
L - LOW

My question is how can I accomplish this in VBA macro or if anyone can
suggest a better way to do this.
Thanks.



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