Excel Attendance sheet with Checkbox

In this video, let us an make attendance sheet by using checkboxes. We need not enter P (Present) or A (Absent). Just click on the check box attendance automatically counted.
**************************************************
Macro :
Sub LinkCheckBoxes()
Dim chk As CheckBox
Dim lCol As Long
lCol = 0 'number of columns to the right of checkbox
lRow = 1
For Each chk In ActiveSheet.CheckBoxes
With chk
.LinkedCell = _
.TopLeftCell.Offset(lRow, lCol).Address
End With
Next chk
End Sub
**************************************************
#advanceexcel #excel

[noyelmelvinserraosj]

Thanks for the wonderful video and the code which helped me lot. But I encountered an error, that is all the true and false details where coming on the next row to checkbookes.
All I had to do was to remove the line which says 'lRow=1' and it worked perfectly fine for me.
Once again thank you for making my work easier. 😅😅

[josephlluvido]

How to save after the code? I couldn't find the option to save. Thank you…

[FlavioFiguereo]

You are the fking man!!! Thank you!!! This video saved me so much time and headaches!!!

[prindamuthukrishnan]

Thank you so much you are the only one provide a correct explanation ❤:)

[janettedupa]

Hello can yoi give that code to activate macros

[james_waynegamingvideos]

Thank you very much, I finally found the exact tutorial I am looking for.

I highly recommend this tutorial to everyone!

[CCAFO]

Thank you! I used your code and it work but when I click on it the True and False show the next cell in below.