Checkbox to insert date in other column

[Kevo85]

Good morning!

I would like when I click the checkbox in column K, that today's date appears in column L. Also I would like that this date be static (won't update when I reopen the file on another date) (It is ok to update the date if I unclick and click again).

I am using checkbox (Excel Menu - Insert - Checkbox (controls).

Thank you

 

[HighAndWilder]

Good morning!

I would like when I click the checkbox in column K, that today's date appears in column L. Also I would like that this date be static (won't update when I reopen the file on another date) (It is ok to update the date if I unclick and click again).

I am using checkbox (Excel Menu - Insert - Checkbox (controls).

Thank you

Try this.

The date will clear when the checkbox is cleared and place the date in the cell to the right when the checkbox is checked.

There is a checkbox there but it does not show in mini-sheets., see image.

Checkbox to insert date in other column.xlsm
	J	K	L	M
1
2			12/02/2025
3
4			12/02/2025
5			12/02/2025
6			12/02/2025
7
8			12/02/2025
9
10
Sheet1

Put this code in the worksheet code module.

Private Sub Worksheet_Change(ByVal Target As Range)
  
  If Not Intersect(Target, ActiveSheet.Range("K:K")) Is Nothing Then
  
    If Target.Value = True Then
    
      With Target.Offset(0, 1)
      
        .Value = Date
        
        .NumberFormat = "DD/MM/YYYY"
      
      End With
    
    Else
    
      Target.Offset(0, 1).ClearContents
      
    End If
    
  End If
  
End Sub

 

[Kevo85]

You sir are awesome! Thank you