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.