| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Case sensitivity of functions in Excel | Excel Worksheet Functions | |||
| Differentiating Case Sensitivity in a Vlookup | Excel Discussion (Misc queries) | |||
| Case Sensitivity in Lookup Functions | Excel Worksheet Functions | |||
| VLookup & Case Sensitivity | Excel Worksheet Functions | |||
Threaded Mode
