Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop down list - display text vs actual value?
Thanks so much Debra/John! I'll give that a try.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get drop-down list to display text and #s but insert only # | Excel Discussion (Misc queries) | |||
How can I display text and #s in a drop-down list, but insert only | Excel Discussion (Misc queries) | |||
How to get drop-down list to display text and #s but insert only # | Excel Discussion (Misc queries) | |||
display text depending on coice from drop down list | Excel Discussion (Misc queries) | |||
Drop-Down List does not display choices | Excel Discussion (Misc queries) |