J
JohnL
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 doesn’t work. How can I
overcome case sensitivity?
TIA
JohnL
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 doesn’t work. How can I
overcome case sensitivity?
TIA
JohnL