how can we add multiple columns with data validation in xl vba

Question

0.00/5 (No votes)

See more:

Is there a way to use data validation on a cell that refers to a list but the combo box shows a multi column range. Example: Cell value needs to be a valid code(A65110, ...). When the drop down box is viewed the user sees a list of projectID's and decription(A65110 Jones Project, ...). When the user selects from the list, the cell is populated with just the code. Access has a feature linking a field (cell) to other fields to assist data input. Does Excel have a similar feature with data validation?
plese help me

Posted 24-Sep-11 0:16am

jincyn

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ChandraRam · Answer 1 · 2011-09-26T09:43:00

As far as I am aware, the functionality as you have described in an Access drop down does not exist in Excel. However, if you can define the data as two columns (one for ID and the other for the corresponding description), you can use the description column for the drop down list, and use VLookUp to pick up the ID. Will that do?