AW: max 1 Zelle von 4 Zellen gültiger Eintrag
20.05.2009 23:36:18
4
Hallo Lemmi,
' **********************************************************************
' Modul: Tabelle1 Typ: Element der Mappe(Sheet, Workbook, ...)
' **********************************************************************
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ErrExit
If Target.Count = 1 Then
If Not Intersect(Target, Range("H6:K1000", "T6:W1000")) Is Nothing Then
Application.EnableEvents = False
If Target = 1 Then
Range(Cells(Target.Row, IIf(Target.Column <= 11, 8, 20)), Cells(Target.Row, IIf(Target.Column <= 11, 11, 23))) = ""
Target = 1
Else
Range(Cells(Target.Row, IIf(Target.Column <= 11, 8, 20)), Cells(Target.Row, IIf(Target.Column <= 11, 11, 23))) = ""
End If
End If
End If
ErrExit:
Application.EnableEvents = True
End Sub
Gruß Sepp