VERY easy question - Xtreme Visual Basic Talk

02-28-2005, 01:18 PM

Alphanumeric Alphanumeric is offline

Junior Contributor

Join Date: Mar 2001

Location: Canada

Posts: 388

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!

__________________
ALPHANUMERIC

02-28-2005, 01:24 PM

HardCode

Ultimate Contributor

Forum Leader
* Expert *

Join Date: Feb 2004

Location: New Jersey

Posts: 3,338

Code:

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.

__________________
DON'T CLICK HERE

Useful forum tags: [VB][/VB], [CODE][/CODE], [HTML][/HTML]

02-28-2005, 01:24 PM

meteo

Ultimate Contributor

Join Date: Aug 2002

Location: Richardson, Texas

Posts: 1,617

UCase and LCase

__________________
WARNING: Self-Taught Programmer. Use at your own risk.
Standards and Practices

Last edited by meteo; 02-28-2005 at 01:24 PM. Reason: Grrrr. HardCode is fast today. = )

02-28-2005, 01:25 PM

grahamt

Junior Contributor

Join Date: Feb 2005

Posts: 247

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

Code:

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

Or see Option Compare Text

02-28-2005, 01:29 PM

Alphanumeric Alphanumeric is offline

Junior Contributor

Join Date: Mar 2001

Location: Canada

Posts: 388

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

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

__________________
ALPHANUMERIC