da sagt er mir dann "mehrdeutiger Name"
13.12.2002 14:53:54
Basti
code is like that:' für Zeiterfassung
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column = 7 And Target.Row >= 5 And Target.Row <> 14 Then
If Target.Value = "" Then
Range("G2") = ""
Else: Range("G2") = WorksheetFunction.VLookup(Target.Value, Sheets("Stammblatt").Range("A20:B50"), 2, False)
End If
End If
End Sub
' für KM-Geld
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column = 2 And Target.Row >= 22 And Target.Row <> 26 Then
If Target.Value = "" Then
Range("G20") = ""
Else: Range("G20") = WorksheetFunction.VLookup(Target.Value, Sheets("Stammblatt").Range("A20:B50"), 2, False)
End If
End If
End Sub
' für verauslagte Kosten
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column = 2 And Target.Row >= 33 And Target.Row <> 37 Then
If Target.Value = "" Then
Range("G31") = ""
Else: Range("G31") = WorksheetFunction.VLookup(Target.Value, Sheets("Stammblatt").Range("A20:B50"), 2, False)
End If
End If
End Sub