Hi,
Im using a code below to update current date automatically in a cell S when there is a specific text in cell Q. Now I would also want the value on cell R to be > 0 before the date is displayed. There should not be matter in which order you fill the cells, so there can be first specific text in cell Q and after that the value in cell R increases or the other way (first cell R increase and after that you change the text in cell Q). Any ideas how to modify the code?
Im using a code below to update current date automatically in a cell S when there is a specific text in cell Q. Now I would also want the value on cell R to be > 0 before the date is displayed. There should not be matter in which order you fill the cells, so there can be first specific text in cell Q and after that the value in cell R increases or the other way (first cell R increase and after that you change the text in cell Q). Any ideas how to modify the code?
VBA Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, [Q:Q]) Is Nothing Then
If UCase(Target) = UCase("Negotiate") Then
Target.Offset(, 2) = Int(Now())
End If
End If
End Sub