Beste wie kan mij deze 2 vba codes combineren. Deze geeft een dubbelzinnige Private Sub Worksheet_Change fout.
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("H20")) Is Nothing Then Exit Sub
Target.Offset(-6, 9) = Format(Now, "dd-mm-yyyy")
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, [U20:U49]) Is Nothing Then Exit Sub
Kelime = Replace(Target.Value, "i", "I")
Kelime = Replace(Kelime, "i", "I")
Target.Value = StrConv(Kelime, vbUpperCase)
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("H20")) Is Nothing Then Exit Sub
Target.Offset(-6, 9) = Format(Now, "dd-mm-yyyy")
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, [U20:U49]) Is Nothing Then Exit Sub
Kelime = Replace(Target.Value, "i", "I")
Kelime = Replace(Kelime, "i", "I")
Target.Value = StrConv(Kelime, vbUpperCase)
End Sub