R
riz.pro
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...
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...