How do I make my list name for drop down box conditional on user e
 

I want a different list referenced for my drop down box when it is employee
103 filling out a form versus employee 105. Employee number is entered by the
user. I tried making the reference equal to a cell name that has the list
name based on the employee's input, but that did not work. Any ideas?

How do I make my list name for drop down box conditional on user e
 

You're probably talking about "dependant lists".

Check out Debra Dalgleish's web page on just this subject:

http://www.contextures.com/xlDataVal02.html

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"duckexceluser" wrote in message
...
I want a different list referenced for my drop down box when it is
employee
103 filling out a form versus employee 105. Employee number is entered by
the
user. I tried making the reference equal to a cell name that has the list
name based on the employee's input, but that did not work. Any ideas?

How do I make my list name for drop down box conditional on usere
 

You can't name a range with a number, so you could name the ranges
Emp105 and Emp103

Then, in the dependent data validation list, use the formula:
=INDIRECT("Emp"&B3)

where cell B3 contains the employee number.

duckexceluser wrote:
I want a different list referenced for my drop down box when it is employee
103 filling out a form versus employee 105. Employee number is entered by the
user. I tried making the reference equal to a cell name that has the list
name based on the employee's input, but that did not work. Any ideas?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html