8 reputation
14
bio website
location
age
visits member for 1 year, 10 months
seen Nov 18 '13 at 19:24

May
9
awarded  Notable Question
Feb
9
awarded  Popular Question
Jan
16
awarded  Informed
Nov
16
comment How to have Excel data validation display different data in drop down than is actually validated
Yeah, I have to agree that the programmatic approach is the only one to completely get it right. Had it so close, too. Can get the drop down list to display what I wanted and save the value to the cell that I wanted, but data validation applied to the displayed list. So the user would drop down the list, select "1122 - Sweet Computer", and "1122" would be entered into the cell. However, the cell was being validated against the list displayed (i.e., "1122 - Sweet Computer") so if the user entered "1122" manually, the cell would fail validation.
Nov
16
awarded  Scholar
Nov
16
comment How to have Excel data validation display different data in drop down than is actually validated
Worksheet_Change is called for any change event but I just throw conditionals in to determine if something changed that I care about and ignore the rest, hence the "If Target.Column" conditional. The drop-down was created using Data Validation against a named range.
Nov
16
accepted How to have Excel data validation display different data in drop down than is actually validated
Sep
26
awarded  Student
Sep
24
asked How to have Excel data validation display different data in drop down than is actually validated