Formula to AUTOMATICALLY Tick Check Box

[elaph]

I want a formula to automatically tick a checkbox. Spreadsheet attached for reference.

[davesexcel]

In design mode, select the first checkbox and then go to the properties of that checked box and in Linked cell, enter C1. Then in C1 enter the formula,=IF(F2=A1,TRUE,FALSE), then exit design mode.
Change the drop down to Progress and the checkbox will be checked.

[kev_]

(a VBA solution)
Attached workbook uses a change event macro to achieve what you want
Can the other checkboxes contain ticks at the same time as each other?
- if not, then activate the 4 lines by removing the apostrophes before each Me.CheckBox1.Value = False
- if they can, then delete those 4 rows

To get at the code Right-Click on Tab name and "View Code"

Please Login or Register  to view this content.