Question about comparing mixed case string values
 

What is the command that tells VBA to treat uppercase and lowercase
characters as the same?

TIA.

-gk-

Question about comparing mixed case string values
 

At the top of the module, use

Option Compare Text

This will cause all text comparisons to be case insensitive.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"TBA" wrote in message
...
What is the command that tells VBA to treat uppercase and
lowercase
characters as the same?

TIA.

-gk-

Question about comparing mixed case string values
 

What do you mean by "treat" them the same? What do want Excel to do? HTH
Otto
"TBA" wrote in message
...
What is the command that tells VBA to treat uppercase and lowercase
characters as the same?

TIA.

-gk-

Question about comparing mixed case string values
 

Either upshift them

UpCase(Range("A1").Value)

or downshift them

LCase(Range("A1").Value)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"TBA" wrote in message
...
What is the command that tells VBA to treat uppercase and lowercase
characters as the same?

TIA.

-gk-

Question about comparing mixed case string values
 

As stated,
Option Compare Text

answers the question asked, but you might not need it.
Also look in VBA help at the strcomp function.

--
Regards,
Tom Ogilvy


TBA wrote in message
...
What is the command that tells VBA to treat uppercase and lowercase
characters as the same?

TIA.

-gk-