AND() , OR() functions in a macro

[jts2004]

I have this:
If [B37].Value = "Y" And [B30].Value = "DOG" And [J2].Value = "X" Then..

I need to include "X" or "x" so the user can enter a capital or lowercase "X"

 

[Joe Was]

If (UCase([B37].Value) = "Y" And UCase([B30].Value) = "DOG" And UCase([J2].Value) = "X") Then..

 

[jts2004]

UCASE

Does UCASE mean any case. like "Dog" or "dOG" or will it only take "DOG" or "X".

 

[Richard Schollar]

At the top of your module, you could include:

Option Compare Text

which I believe will have the same result as Joe's code. However, if you choose this option, then all your other subs in this module will behave in the same way (which you may not want).

Regards

Richard

 

[Richard Schollar]

The Ucase method will cast any string value passed to it as Uppercase. In other words:

dog will become DOG
Dog ................ DOG
doG ................ DOG

etc

Richard

 

[Joe Was]

UCase() tells the compair to match any combimation of cases in the cell to a string indicated in all Capitals, as if the cell has only capitals when it does not.

 

[jts2004]

thanks

This works