[go: up one dir, main page]
Scribd
Upload
27 views1 page

Vba Code Mannual

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
27 views1 page

Vba Code Mannual

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
You are on page 1/ 1

Directly applying Check Box:

Sub LinkChecklist()

Dim chk As CheckBox

For Each chk In ActiveSheet.CheckBoxes

chk.LinkedCell = chk.TopLeftCell.Offset(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