Case sensitivity
I have created a Private Sub Worksheet_Change(ByVal Target As Range), with a
Select Case argument. When the value of cell D6 is equal to €śHOUSE€ť, then
the interior color of cell A8 becomes yellow.
But if the user enters €śHouse€ť in cell D6, then it doesnt work. How can I
overcome case sensitivity?
TIA
JohnL
|