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
Sandra SmithRetiredAsked:
Who is Participating?
 
Martin LissConnect With a Mentor Older than dirtCommented:
Here's an article that describes a workaround.
0
 
Sandra SmithRetiredAuthor Commented:
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.
0
 
Martin LissOlder than dirtCommented:
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.
0
 
Martin LissOlder than dirtCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.