non case specific
 

my code reads:
if variable1 = "excluded" then
call abc
else
call def
end if

my problem is 'variable1' is typed in by users and can be 'Excluded',
'EXCLUDED', and other combinations of caps and lower case letters. I want
to include any and all combination of upper and lower case letters, as long
as the spelling is correct. I am sure there is something I can wrap around
'variable1', but I don't know it. Thanks, Mike Allen

non case specific
 

Check this out:

http://www.excel-vba.com/v-functions.htm
See the lcase section, should show you how.

non case specific
 

There are options re case sensitivity set for the module via Option statements
at the top. The simplest solution to you current question is to use

If LCase$(Variable1) = "excluded" Then

On Fri, 21 Jan 2005 12:14:07 -0600, "mike allen"
wrote:

my code reads:
if variable1 = "excluded" then
call abc
else
call def
end if

my problem is 'variable1' is typed in by users and can be 'Excluded',
'EXCLUDED', and other combinations of caps and lower case letters. I want
to include any and all combination of upper and lower case letters, as long
as the spelling is correct. I am sure there is something I can wrap around
'variable1', but I don't know it. Thanks, Mike Allen

non case specific
 

As convention I always use Ucase but you could use lcase

if lcase(variable1) = "excluded" then

Chips web link gives you a lot more info on this kind of thing though... You
should take a look at it.

HTH

"mike allen" wrote:

my code reads:
if variable1 = "excluded" then
call abc
else
call def
end if

my problem is 'variable1' is typed in by users and can be 'Excluded',
'EXCLUDED', and other combinations of caps and lower case letters. I want
to include any and all combination of upper and lower case letters, as long
as the spelling is correct. I am sure there is something I can wrap around
'variable1', but I don't know it. Thanks, Mike Allen

non case specific
 

if lcase(variable1) = "excluded" then
call abc
else
call def
end if

--
Regards,
Tom Ogilvy