AW: ZÄHLENWENN
01.06.2008 17:42:46
Jörg
Was ist neu an der Formel
mit If
anstatt Case.
Meine gesamter Code lautet
Private Sub Worksheet_Change(ByVal Target As Range)
Dim RowCount As Integer
Application.EnableEvents = False
Select Case Target.Value
Case "1a"
Target.Value = "5:45-13.00"
Target.Offset(1, 0).Value = "Kasse"
Case "18"
Target.Value = "18:00-00.00"
Target.Offset(1, 0).Value = ""
Target.Offset(0, 1).Value = "00:00-02:00"
Target.Offset(1, 1).Value = ""
Case "17"
Target.Value = "17:00-00.00"
Target.Offset(1, 0).Value = ""
Target.Offset(0, 1).Value = "00:00-01:00"
Target.Offset(1, 1).Value = ""
Case "19"
Target.Value = "19:00-00.00"
Target.Offset(1, 0).Value = ""
Target.Offset(0, 1).Value = "00:00-03:00"
Target.Offset(1, 1).Value = ""
Case "3a"
Target.Value = "20:45-00.00"
Target.Offset(1, 0).Value = "Shit"
Target.Offset(-2, 1).Value = "00:00-06:00"
Target.Offset(-1, 1).Value = "Shit"
Case "1n"
Target.Value = "6:00-12.45"
Target.Offset(1, 0).Value = ""
Case "3"
Target.Value = "20:45-00:00"
Target.Offset(1, 0).Value = ""
Case "a"
Target.Value = "00:00-06:00"
Target.Offset(1, 0).Value = ""
Case "2a"
Target.Value = "12:45-21.00"
Target.Offset(1, 0).Value = "Kasse"
Case "2"
Target.Value = "13:00-21.00"
Target.Offset(1, 0).Value = ""
Case "7"
Target.Value = "7:00-15.00"
Target.Offset(1, 0).Value = ""
Case "8"
Target.Value = "8:00-16.00"
Target.Offset(1, 0).Value = ""
Case "9"
Target.Value = "9:00-17.00"
Target.Offset(1, 0).Value = ""
Case "10"
Target.Value = "10:00-18.00"
Target.Offset(1, 0).Value = ""
Case "16"
Target.Value = "16:00-24.00"
Target.Offset(1, 0).Value = ""
Case "1"
Target.Value = "5:45-13.15"
Target.Offset(1, 0).Value = ""
Case "DB"
Target.Value = "18:00-20.00"
Target.Offset(1, 0).Value = "DB"
Case "Dspwg1"
Target.Value = "8:30-12.30"
Target.Offset(1, 0).Value = "Dsp.-Walk"
Target.Offset(2, 0).Value = "Gottm."
Case "Dspwg2"
Target.Value = "12:30-16.30"
Target.Offset(1, 0).Value = "Dsp.-Walk"
Target.Offset(2, 0).Value = "Gottm."
Case "Dspv"
Target.Value = "7:45-11.45"
Target.Offset(1, 0).Value = "Dsp.-Volley"
Target.Offset(2, 0).Value = "Ehingen"
Case "Dspb"
Target.Value = "9:30-13.30"
Target.Offset(1, 0).Value = "Dsp.-Baske"
Target.Offset(2, 0).Value = "Ehingen"
Case "Dspf"
Target.Value = "9:00-13:00"
Target.Offset(1, 0).Value = "Dsp.-Fuss"
Target.Offset(2, 0).Value = "Ehingen"
Case "Dspfff"
Target.Value = "14:30-18.30"
Target.Offset(1, 0).Value = "Dsp.-FFF"
Target.Offset(2, 0).Value = "Randegg"
Case "WSVB"
Target.Value = "13:00-17.00"
Target.Offset(1, 0).Value = "WSV"
Target.Offset(2, 0).Value = "Büssl."
Case "WSVE"
Target.Value = "7:45-11:45"
Target.Offset(1, 0).Value = "WSV"
Target.Offset(2, 0).Value = "Ehingen"
Case "Scht1"
Target.Value = "07:00-10:30"
Target.Offset(1, 0).Value = "SCH/Te."
Case "Scht2"
Target.Value = "09:00-12:30"
Target.Offset(1, 0).Value = "SCH/Te."
Case "Schi1"
Target.Value = "06:45-10:45"
Target.Offset(1, 0).Value = "SCH/Im."
Case "Schi2"
Target.Value = "08:45-12:45"
Target.Offset(1, 0).Value = "SCH/Im."
Case "BD-1"
Target.Value = "7:30-12:00"
Target.Offset(1, 0).Value = "12:30-16:30"
Target.Offset(2, 0).Value = "BD"
Case "BD-2"
Target.Value = "8:30-12:00"
Target.Offset(1, 0).Value = "12:30-17:30"
Target.Offset(2, 0).Value = "BD"
End Select
Application.EnableEvents = True
End Sub