topic Re: Case-INsensitive Select...Case in VBA Forum

Case-INsensitive Select...Case

Anonymous — Tue, 10 Jul 2001 12:00:12 GMT

I'm using Select...Case statements to deal with layer names and block names,
the problem is some blocks are created with all uppercase letters while
others use all lowercase. Some even use mixed case!!! This causes the
counter to incorrectly tally items or c ompletely skip entities I clearly
have in my drawing (they are visible). My question is, how do I tell the
Select...Case loop that CASE "pu-wat" is the same as CASE "PU-WAT" is the
same as CASE "Pu-Wat" without speeling out every possible combination of
upper/lower case letters? Thanks,

Re: Case-INsensitive Select...Case

Anonymous — Tue, 10 Jul 2001 12:05:19 GMT

use the UCase function to convert your string to all uppercase before you
test with a Select... Case loop
then your Case statement can test for the all uppercase version only.

"Scott" wrote in message
news:B120667F300EDADD3830D54E18F6BF65@in.WebX.maYIadrTaRb...
> I'm using Select...Case statements to deal with layer names and block
names,
> the problem is some blocks are created with all uppercase letters while
> others use all lowercase. Some even use mixed case!!! This causes the
> counter to incorrectly tally items or c ompletely skip entities I clearly
> have in my drawing (they are visible). My question is, how do I tell the
> Select...Case loop that CASE "pu-wat" is the same as CASE "PU-WAT" is the
> same as CASE "Pu-Wat" without speeling out every possible combination of
> upper/lower case letters? Thanks,
>
>
>
>

Re:

Anonymous — Tue, 10 Jul 2001 13:21:13 GMT

thanks,

"Corey A. Layton" wrote in message
news:16F779F6D1B976AAF7793AE2AAAE3B90@in.WebX.maYIadrTaRb...
> use the UCase function to convert your string to all uppercase before you
> test with a Select... Case loop
> then your Case statement can test for the all uppercase version only.
>
> "Scott" wrote in message
> news:B120667F300EDADD3830D54E18F6BF65@in.WebX.maYIadrTaRb...
> > I'm using Select...Case statements to deal with layer names and block
> names,
> > the problem is some blocks are created with all uppercase letters while
> > others use all lowercase. Some even use mixed case!!! This causes the
> > counter to incorrectly tally items or c ompletely skip entities I
clearly
> > have in my drawing (they are visible). My question is, how do I tell the
> > Select...Case loop that CASE "pu-wat" is the same as CASE "PU-WAT" is
the
> > same as CASE "Pu-Wat" without speeling out every possible combination of
> > upper/lower case letters? Thanks,
> >
> >
> >
> >
>
>

Re: Case-INsensitive Select...Case

Anonymous — Tue, 10 Jul 2001 13:23:56 GMT

Hi Scott,

If You put "Option Compare Text" in the declarations section of Your module,
then all text comparsions are done case insensitiv in the whole module.

/ Per Nilsson

"Scott" skrev i meddelandet
news:B120667F300EDADD3830D54E18F6BF65@in.WebX.maYIadrTaRb...
> I'm using Select...Case statements to deal with layer names and block
names,
> the problem is some blocks are created with all uppercase letters while
> others use all lowercase. Some even use mixed case!!! This causes the
> counter to incorrectly tally items or c ompletely skip entities I clearly
> have in my drawing (they are visible). My question is, how do I tell the
> Select...Case loop that CASE "pu-wat" is the same as CASE "PU-WAT" is the
> same as CASE "Pu-Wat" without speeling out every possible combination of
> upper/lower case letters? Thanks,
>
>
>
>