Attendance sheet with #Checkbox in #Excel .
#How to Create employee attendance sheet with checkbox. You need not to enter P or A for Present and absent.
Just click on the checkbox attendance automatically counted. All the unchecked checkboxes counted as absents.
In this video I am Going to Tell you how you can make attendance sheet including checkboxes in #Excel.
#exceltricks #Exceltips #exceltutorials #reels #fbvideos #HR
VBA Code :
------------------------------
'CODE by Itxperts
Sub LinkCheckBoxes()
Dim chk As CheckBox
Dim lCol As Long
lCol = 0 'number of columns to the right for link
For Each chk In ActiveSheet.CheckBoxes
With chk
.LinkedCell = _
.TopLeftCell.Offset(0, lCol).Address
End With
Next chk
End Sub
------------------------------------------------------
