case sensitivity check for List values
 

hi,

i have a list of values something like this..
"Priority"----this is the header.
Blocking
High
Medium
Low
i have deifned a name for this list. A column of cells can contain
only these values, user have been provided dropdown for selecting from
this list.

but the problem is...if a user types "blocking" instead of selecting
"Blocking" from the dropdown, the cell takes a value as "blocking"
and never prompt it as an error. I have written a perl script that
reads these values and puts them in the database. the database
integrity goes for a toss if this value is put in it.
Is there a way or a macro(that can be written)to provide a check for
case sensitivity...?
I also have other lists that dont fit the PROPER, UPPER OR LOWER case
the list can be a mixture of all these..

to make matters worse i am new to using excel and have very faint idea
about writing excel macros..
Please HELP...

case sensitivity check for List values
 

You could try a formula in the DV like so

=EXACT(L1,INDEX(O:O,MATCH(L1,O:O,0)))

where L1 is the DV cell, O is where the list is held.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



wrote in message
ups.com...
hi,

i have a list of values something like this..
"Priority"----this is the header.
Blocking
High
Medium
Low
i have deifned a name for this list. A column of cells can contain
only these values, user have been provided dropdown for selecting from
this list.

but the problem is...if a user types "blocking" instead of selecting
"Blocking" from the dropdown, the cell takes a value as "blocking"
and never prompt it as an error. I have written a perl script that
reads these values and puts them in the database. the database
integrity goes for a toss if this value is put in it.
Is there a way or a macro(that can be written)to provide a check for
case sensitivity...?
I also have other lists that dont fit the PROPER, UPPER OR LOWER case
the list can be a mixture of all these..

to make matters worse i am new to using excel and have very faint idea
about writing excel macros..
Please HELP...