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

свернуть