danielpt78
New Member
- Joined
- Mar 5, 2022
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
Hi, i want to uncheck the checkbox when a cell value is changed. However, i need to make a cycle for each one. For now, i only have my checkboxes associated to each cell with this code:
The cell that changes value is not the one that it's associated with the checkbox.
If, for example, the cell A2 goes from 3 to 10 the checkbox in the F2 unticks.
I am a newbie in VBA so if sorry if this is a bit confusing.
VBA Code:
Sub LinkChecklist()
Dim chk As CheckBox
For Each chk In ActiveSheet.CheckBoxes
chk.LinkedCell = chk.TopLeftCell.Offset(1, 0).Address
Next
End Sub
The cell that changes value is not the one that it's associated with the checkbox.
If, for example, the cell A2 goes from 3 to 10 the checkbox in the F2 unticks.
I am a newbie in VBA so if sorry if this is a bit confusing.