hi i have a validation list with a dropdown menu. but i dont want to have them case sensitive
i found this
on the site but i dont get itOriginally Posted by Carim
Hi,
Instead of using a named range, you would have to type your list in
the data validation dialog box.
HTH
Carim
i have done what it says and it still flags up an error when i do it with caps lock on
any ideas??
I dont like to use code i dont understand
it makes it hard to use in other situations
so please try to be as clear and patent as possible with me
Criticism is welcomed
I am using Excel 2000 and the validation list is not case sensitive if you references a named range but is case sensitive if you use a list within the Data Validation text box. Maybe you have it backwards?
ChemistB
as in
jan,feb,mar,apr ect
in the validation box
where you would select the range??
Instead of typing your list into the data validation box after choosing List, have your list somewhere in the spreadsheet and either type in the range (e.g. B6:B15) or once your cursor is in that box, highlight the range and it should appear there.
ChemistB
THANKS =) ChemistB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks