Welcome Guest.

3Answers

Enter the number in the cells of spreadsheets A1, B1, and C1. After the carriage return, how to make the D1, E1, and F1 cells automatically display the input time.

Asked by: Diane Campbell 209 views Software October 20, 2018

Enter the numbers in the cells of the spreadsheets A1, B1, and C1. After the carriage return, how to make the D1, E1, and F1 cells automatically display the input time. After changing the A1, B1, and C1 cells, enter the number D1. , E1, F1 cells also automatically display the time of modification

3 Answers

  1. +8Votes  

    Private Sub Worksheet_Change(ByVal Target As Range)

    On Error GoTo 100

    If Target.Address = "$A$1" And Application.IsNumber(Target) Then [d1] = Time()

    If Target.Address = "$B$1" And Application.IsNumber(Target) Then [e1] = Time()

    If Target.Address = "$C$1" And Application.IsNumber(Target) Then [f1] = Time()

    100

    End Sub

    Demo:

    Ann Jones- October 21, 2018 |

  2. +7Votes  

    This requires “Worksheet Events” VBA code implementation.

    Wright- October 21, 2018 |

  3. +4Votes  

    This feature can only be done in VBA

    Question: What do you do? Is there any code?

    Brian Lee- October 21, 2018 |