Timestamp in Column AC when box is checked in column A

[boivinjoe121]

Hello,

I have a sheet with multiple rows of data. In column A there are check boxes. What I need is code that puts a timestamp in column AC when the box is checked in column A of the same row. Column AC is also the last Column of the row if that is helpful.

Thanks, new to VBA and trying to figure all this out.

JB

 

[DanteAmor]

Hi and welcome to MrExcel.

In column A there are check boxes.

Are the checkbox controls of Form or ActiveX?
Does the control have a linked to a cell?

Eg:
For Form control:

For Activex Control:

 

[boivinjoe121]

Checkbox controls are form and it does not have a link.

 

[DanteAmor]

it does not have a link.

Without a link it is difficult to determine which checkbox you pressed.
Or you should add a macro for each checkbox.
If you decide to make the link with one cell for each checkbox, tell me in which cell you will make the reference.

 

[Fluff]

You can assign this code to all the checkboxes & it will put a date time stamp in col AC for the row where the top left corner of the checkbox is.

Sub boivinjoe()
   Dim Shp As Shape
   
   Set Shp = ActiveSheet.Shapes(Application.Caller)
   Range("AC" & Shp.TopLeftCell.Row).Value = Date + Time
End Sub