Data Validation List

[AK]

I have assigned codes to some items such as

01 Item A

02 Item B

This information is in different columns.


I have combined this information and assigned it as a list for data validation for a cell. What I want is after I select an entry in the data validation list, I only want the item name and not the item code populated in the cell


e.g. I will select '01 Item A' in the dropdown and what gets populated is 'Item A'.


Can this be done without using VBA?

 

[Hui]

No,

But it can be done with VBA

 

[Hui]

AK

There is a very good article on what can be done with validation and VBA at

http://blog.contextures.com/archives/2009/09/18/select-multiple-items-from-excel-data-validation-list/