this part of code font bold![]()
Private Sub Worksheet_Change(ByVal Target As Range) With Target If .Count > 1 Then Exit Sub If .Column = 3 Then If .Value = "m/c interest" Then .Offset(, 2).Value = Range("L2").Value ElseIf .Value = "interest" Then .Offset(, 2).Value = Range("L3").Value .Offset(, -1).Value = DateSerial(Year(Now), Month(Now) + 1, 0) ElseIf .Value = "web internet" Then .Offset(, 2).Value = Range("L4").Value ElseIf .Value = "cell phone" Then .Offset(, 2).Value = Range("N2").Value End If ElseIf .Column = 5 Then .Offset(, -3).Value = Date ActiveSheet.Unprotect "r" Target.Locked = True ActiveSheet.Protect "r" End If End With End Sub
Thanks![]()
.Offset(, -1).Value = DateSerial(Year(Now), Month(Now) + 1, 0)











LinkBack URL
About LinkBacks
Register To Reply
Bookmarks