Hi All,

I'm trying to limit acceptable entries in a document I'm creating.
What I'm trying to do is make it so a user can only enter part numbers from
a specific list. The list is 34 part numbers long.

I've created the list and went to InsertNameDefine, and named this list as
'CH', and then gone into DataValidation then Allowed 'List', and the Source
as =CH for cells A4:A65536.

When this is done, I can choose any of the 34 parts from the list, but when
I try to manually enter any value except the first, I get an error message
saying "The
value you entered is not valid. A user has restricted values that can be
entered into this cell."

I want to be able to either type the number in, or choose it from the list.


Any ideas? I am using Excel 2000.

Thanks,