VERY easy question

Hello.

I'm sorry, it's been a while since I've done this, and I can't recall the correct syntax. How do I ignore the case using the Left$() and Right$() statements?

For example........

If Left$(Variable, 1) = "a" Then MsgBox "Hello!"

Variable could possibly be "a" or "A".


Thanks!

If LCase(Left$(Variable, 1)) = "a" Then MsgBox "Hello!"

If UCase(Left$(Variable, 1)) = "A" Then MsgBox "Hello!"


Alternatively, you can put Option Compare Text at the top of the code sheet, after your Option Explicit.

UCase and LCase

You could force it to be upper or lower ...


If Left$(UCase(Variable), 1) = "A" Then MsgBox "Hello!"


Or see Option Compare Text

Haha, I feel so stupid now. I've been using LCase and UCase elsewhere in my program too. :o

How could I have forgotten? Hah, oh well. Thanks for your help! :D