Entering a date stamp if a value in cell is True

[Bill Williamson]

Hello everyone,

Couldnt seem to find the correct formula for what I am trying to do.
In Column O There will be a Yes or a No depending on Checkbox selection on userform. Say cell O2 is entered or changed to true then I want cell P2 to have a non changing date stamp.

here is a screen shot of Data sheet.

Thanks in advance,

Bill Williamson

https://www.dropbox.com/s/bb6566rm07lexjd/Screenshot 2019-11-11 12.35.49.png?dl=0

 

[Paul Ked]

Put this in the Sheet1 code module:

Option Explicit


Private Sub Worksheet_Change(ByVal Target As Range)
    With Application
        .EnableEvents = False
        If Target.Column = 15 And Target.Row <> 1 Then Cells(Target.Row, 16).Value = Date + Time
        .EnableEvents = True
    End With
End Sub

 

[Bill Williamson]

Paul

That worked great.

Thank you,


Bill Williamson

 

[Paul Ked]

You're welcome

 

[Bill Williamson]

OK I have a question. If I have a date stamp issue, but it is not related to the prior code helped with.
Do I still ask in this thread or should I start a new one?

Thanks,

Bill

 

[Paul Ked]

I'd start a new thread