It is always a good idea to show the code you are using for the problem area
you are asking your question about. My guess is for you to use the UCase
function on the argument to the Select Case statement and then test the
individual Case statements against upper case text. For example...

Select Case UCase(Target.Value)
Case "HOUSE"
....
Case "ROOM"
....
etc.
End Select

--
Rick (MVP - Excel)


"JohnL" wrote in message
...
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