Data validation allows user to type any value

Zzyzzyth

Board Regular
Joined
Feb 19, 2002
Messages
145
I have searched and can't find an answer.

I've never had this problem before.
Define a list, if the user tried to type something else, an error displayed. Done.

I've tried Unfreeze panes, copying to a new workbook, none of it has helped. I'm totally lost.

The list still allows the users to type whatever they wish. Allow blnks checked (because I need a blank as an option).
In cell dropdown checked. Any ideas??
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

d0wnt0wn

Well-known Member
Joined
Oct 28, 2002
Messages
771
go to data.... validation...click on the error alert tab...... and uncheck :eek:)
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Goto Data-->Validation-->Error Alert-->Check Show Error. To have the option of selecting a blank, you can add a blank to your validation list.

HTH,

Smitty
 

d0wnt0wn

Well-known Member
Joined
Oct 28, 2002
Messages
771
errr i miss read you a bit there... make sure the error alert box is checked
 

Zzyzzyth

Board Regular
Joined
Feb 19, 2002
Messages
145

ADVERTISEMENT

It is checked, I've actually tried both. It still allows the user to type whatever they want. It's baffling, they've always worked for me before.
 

SIXTH SENSE

Well-known Member
Joined
Oct 29, 2003
Messages
1,883
hi!
Try Deleting the data validations then reaply it.some messy bugs maybe arround! I have experienced it before too.
 

d0wnt0wn

Well-known Member
Joined
Oct 28, 2002
Messages
771
another thing you may be doing.... is typing something that is already on the list.... just in case you havnt tried this... try typing in some useless babble... if what you type is in the validation list it will allow it
 

Zzyzzyth

Board Regular
Joined
Feb 19, 2002
Messages
145
Yeah, I've tried that, too. Deleted the list name, re-named it, re-applied the validation - I'm stumped. As far as the useless babble - that's the problem! It allows the useless babble!! (which is NOT in the list)
 

Forum statistics

Threads
1,147,844
Messages
5,743,511
Members
423,800
Latest member
IuneKeiki

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top