asked on

Deliminted list for Data Validation in Excel 2010

Is there a way to create a two-column list to use in the Data Validation process in Excel 2010? have a list like:

ResouceID ResourceType
PrjMgr Project Manager
RscMgr Resource Manager
RSC Resource

But in the drop-down in the cell, to control data, I need both columns to appear as the user may not know what each ResourceID refers to.

Sandra

ASKER CERTIFIED SOLUTION

Martin Liss

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Sandra Smith

ASKER

Thanks, but that really does not work as users will add and delete from the column, which means the combobox could deleted and I need a field in each row. I do not think there is n answer in that I cannot do what I want, but thank you for trying to help. This simply proved what I want to do I not possible.

Martin Liss

Please see my "The magical floating ActiveX control" artcle which was originally based on similar code. With this solution and the proper range setting the combobox will show up.

Martin Liss

I just checked my article and as it's set up will show the combobox in any cell that has data validation, but you can change the following line to specify a range instead.

If Target.Validation.Type = 3 Then