I have a worksheet called "Data". When I Tab through cell "D4" and the cell is empty, I want a checkbox called "CBX_P3" which is in Module 3 of the workbook to be clicked. If I type something in the cell and then Tab out, I want a checkbox called "CBX_Q3" to be clicked.
I can set these checkboxes to true or false but when I physically click them, they trigger a bunch of other events whereas by just setting them to true or false, they appear checked but the other events are not triggered. That's my problem.
They are formfield checkboxes in Excel 2010 but just in a worksheet, not on a form.
This is what I've tried but it gives me an error message:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Range("D4"), Target) Is Nothing Then
CBX_PB3.Value = True
MsgBox "D4 has changed"
Thanks for any suggestions!