My question:

I want to compare strings the way "Option Compare Text" does.
So, "a"="A" !
BUT, I just want to enable this in one procedure!

THANK YOU
Cu SimonC

My question:

I want to compare strings the way "Option Compare Text" does.
So, "a"="A" !
BUT, I just want to enable this in one procedure!

THANK YOU
Cu SimonC

You can use LCase$() or UCase$() functions to convert both strings to
the same case and then compare them:

    If Ucase$(String1) = Ucase$(String2) then

   End If

Regards,
                Stoil

If StrComp(String1, String2, vbTextCompare) = 0 Then
        MsgBox "Strings are equal"
End If

On Wed, 2 Jun 1999 20:27:01 +0200, "S.C. Pfender"