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...

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)



<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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...
>