Solved

Deliminted list for Data Validation in Excel 2010

Posted on 2013-12-22
4
492 Views
Last Modified: 2013-12-22
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
0
Comment
Question by:ssmith94015
  • 3
4 Comments
 
LVL 46

Accepted Solution

by:
Martin Liss earned 500 total points
ID: 39734880
Here's an article that describes a workaround.
0
 

Author Closing Comment

by:ssmith94015
ID: 39734921
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
 
LVL 46

Expert Comment

by:Martin Liss
ID: 39735000
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
 
LVL 46

Expert Comment

by:Martin Liss
ID: 39735004
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

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question