Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation Error Message | Excel Discussion (Misc queries) | |||
Data Validation error message | Excel Worksheet Functions | |||
Validation - Error message if equals Left formula | Excel Worksheet Functions | |||
Data Validation Message | Excel Discussion (Misc queries) | |||
Error Message with Data Validation | Excel Discussion (Misc queries) |