Drop down list - display text vs actual value?
 

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.

Drop down list - display text vs actual value?
 

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

Drop down list - display text vs actual value?
 

or a combobox from the forms toolbar which shows low med high,another cell
uses =choose(cell link,"L","M","H")
--
paul
remove nospam for email addy!



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

Drop down list - display text vs actual value?
 

Thanks so much Debra/John! I'll give that a try.