On 2002-04-04 15:49, bobmc wrote:
Anyone?
I don't think this is possible, because I keep getting caught in an endless loop when I clear the contents in the "other cells"
The entry in cell 1 clears the other two, but that clearing triggers the worksheet_change event again and again.
Here is what I have so far. Possibly otehrs can take this and run with it.
-------------------
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column > 26 And Target.Column < 32 Then
If Target.Row = 13 Then
Cells(14, Target.Column).ClearContents
Cells(15, Target.Column).ClearContents
Application.EnableEvents = False
Exit Sub
End If
If Target.Row = 14 Then
Cells(13, Target.Column).ClearContents
Cells(15, Target.Column).ClearContents
Application.EnableEvents = False
Exit Sub
End If
If Target.Row = 15 Then
Cells(13, Target.Column).ClearContents
Cells(14, Target.Column).ClearContents
Application.EnableEvents = False
Exit Sub
End If
End If
Application.EnableEvents = True
End Sub
--------------------------
This may get someone started.
Bye,
Jay