Error message when trying data validation
 

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,

Error message when trying data validation
 

You can enter by hand but you must match the list exactly. That means that if
your list is text then your entry must also be text. Other than that make
sure that blank spaces are correct and that there is no blanks padded at the
ends of your part numbers in the list.
--
HTH...

Jim Thomlinson


"Cam1234" wrote:

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,

Error message when trying data validation
 

It seems my list is too long to be entered in. I got to part number 24, and
it wouldn't let me enter any more.

Any more ideas?

Thanks for your time so far.

"Jim Thomlinson" wrote:

You can enter by hand but you must match the list exactly. That means that if
your list is text then your entry must also be text. Other than that make
sure that blank spaces are correct and that there is no blanks padded at the
ends of your part numbers in the list.
--
HTH...

Jim Thomlinson


"Cam1234" wrote:

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,

Error message when trying data validation
 

Uncheck "Show error alert after invalid data has been entered" on the Error
Alert tab.


Gord Dibben MS Excel MVP

On Tue, 1 Apr 2008 12:23:00 -0700, Cam1234
wrote:

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,