Hi there
My Excel Vba shown below inserts time() into a particular cell on my sheet.
Once inserted, is it possible to clear this cell before my vba code is re-run?.
My VBA is only entering the time() once and not re-insering the time() if i change the same cell values after some time i.e.
please advice
Private Sub DateModifier(ByVal strTarget As String, ByVal strDestination As String) ' Checks for a Yes or NA or RB(Rollback) value in strTarget and if found, modifies the cell in strDestination If (Range(strTarget + strCurrentRow).Value2 = "Yes") Then If (Range(strDestination + strCurrentRow).Value2 = "") Then Range(strDestination + strCurrentRow).Value2 = StaticTime End If ' Check to see if Log has been rolled back If (Range(strDestination + strCurrentRow).Value2 Like ("Rolled Back*")) Then Range(strDestination + strCurrentRow).Value2 = StaticTime End If End If ' Check for an NA status If (Range(strTarget + strCurrentRow).Value2 = "NA") Then If (Range(strDestination + strCurrentRow).Value2 = "") Then Range(strDestination + strCurrentRow).Value2 = "NA" End If End If ' Check to see if strTarget changes to "No" but originally was yes ' (if a value is in strDestination we assume a log has happened) ' and append the log with Rolled Back and the date If (Range(strTarget + strCurrentRow).Value2 = "RB") Then If Not (Range(strDestination + strCurrentRow).Value2 = "") Then If Not (Range(strDestination + strCurrentRow).Value2 Like "*RB*") Then Range(strDestination + strCurrentRow).Value2 = "RB" + StaticTime End If End If End If End Sub