Can a change in a cell, done by VBA, be a trigger for Workbook_SheetChange?

[Mster_Dev24]

Hi everyone
Im currently trying to deselect a checkbox then a value in a cell are automatically changed to "0" by VBA. I trying to to use the "Workbook_SheetChange"-function but it seems to not work then the value in the actual cell (A1) are automatically changed/updated by a VBA-rutine.

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

If Range("A1")="0" then
   ActiveSheet.CheckBoxes("Kryssruta 137").Value = False

Else
EndIf

EndSub

Are there please anyone who can confirm this and what to do instead?

 

[RoryA]

Changing the value of a cell via a linked control doesn't trigger a Change event unfortunately. The simplest option is to change the linked cell value directly in your code, which will also update the control.