Scribd
Upload
30 views1 page

VBA for Checkbox Linked Cells

This document provides code to directly link checkboxes on a worksheet to cells. It uses a For Each loop to iterate through all checkboxes on the active sheet, setting each checkbox's LinkedCell property to the address of the cell immediately to the left of its top left corner. It also shows a conditional formatting formula that will format cells the same if the value in column D is "Contract" and cell N11 is true.

Uploaded by

Binod Raj Giri
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
30 views1 page

VBA for Checkbox Linked Cells

This document provides code to directly link checkboxes on a worksheet to cells. It uses a For Each loop to iterate through all checkboxes on the active sheet, setting each checkbox's LinkedCell property to the address of the cell immediately to the left of its top left corner. It also shows a conditional formatting formula that will format cells the same if the value in column D is "Contract" and cell N11 is true.

Uploaded by

Binod Raj Giri
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Directly applying Check Box:

Sub LinkChecklist()

Dim chk As CheckBox

For Each chk In [Link]

[Link] = [Link](0, -1).Address

Next

End Sub

Conditional Formating the check Box

=AND($D1=”Contract”,$N$11)

i.e. if D column value is contract and n11 is true all color becomes same

You might also like