View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_3_] Jim Thomlinson[_3_] is offline
external usenet poster
 
Posts: 983
Default 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