Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False If Not Intersect(Target, Range("I3:J14")) Is Nothing Then Target.Value = CDate(Left(Target, 2) & "." & Mid(Target, 4, 2) & "." & Range("A1").Value) End If Application.EnableEvents = True End Sub
Wenn ich A1 ändere soll der Bereich auch geändert sein.
Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Dim rngC As Range, rngBer As Range Application.EnableEvents = False Set rngBer = Range("I3:J14") If Not Intersect(Target, rngBer) Is Nothing Then Target.Value = CDate(Left(Target, 2) & "." & Mid(Target, 4, 2) & "." & Range("A1").Value) ElseIf Not Intersect(Target, Range("A1")) Is Nothing Then For Each rngC In rngBer If rngC.Value <> "" Then rngC.Value = CDate(Day(CDate(rngC)) & "." & Month(CDate(rngC)) & "." & Range("A1").Value) End If Next End If Application.EnableEvents = True End Sub
58.4k Fragen
249k Antworten
7k Nutzer