Validation Using A List Box
 

I am using validation in the "LIST" part of it, I need it to give me more
length. It will only let me input a certain amount of characters and then
stops. Is there a way to extend this, or possibly another solution.

I am using it to input times for a schedule, we want the managers to only
select the times we input in a drop down box for them. Any other ideas would
me great!

Thanks

Validation Using A List Box
 

Assuming your schedule times from A1:A100

What you can do is to define a named range.

go insert-name-define

Type a ranged name like "TestRange" and reference it to A1:A100

In the cell which you want to validate using a List,

Click Allow:List

Source: =TestRange

And presto. done

--
KellTaine
-----------------------------------------------------------------------
KellTainer's Profile: http://www.excelforum.com/member.php...fo&userid=3432
View this thread: http://www.excelforum.com/showthread.php?threadid=54905