cmefly
Well-known Member
- Joined
- May 13, 2003
- Messages
- 683
Hi,
i have the following macro and i'm unsure how to make it work properly:
Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Range("c35").Value
Case "X"
Range("C37").ClearContents
End Select
Select Case Range("c37").Value
Case "X"
Range("C35").ClearContents
Exit Sub
End Select
End Sub
c35 and c37 are drop-down menus that contain either "X" or Blank. So when selecting X in either one, the other should result to Blank - but then this activates the first one and so only the first part really works....
any suggestions??
thanks,
Marc
i have the following macro and i'm unsure how to make it work properly:
Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Range("c35").Value
Case "X"
Range("C37").ClearContents
End Select
Select Case Range("c37").Value
Case "X"
Range("C35").ClearContents
Exit Sub
End Select
End Sub
c35 and c37 are drop-down menus that contain either "X" or Blank. So when selecting X in either one, the other should result to Blank - but then this activates the first one and so only the first part really works....
any suggestions??
thanks,
Marc