mardi 19 mai 2015

Updating linked checkboxes

I am struggling try to solve an easy problem. I have check boxes in Sheet 1 and check boxes in sheet 2 that have to assume the same vale (TRUE or FALSE) of the ones in Sheet 1. The problem is that when i open Sheet 2 they are not marked but i have to click on them with the mouse.

I'm using this code:

Sheet2.chk_2A.Value = Sheet1.chk_1a.Value

Am I forgetting an auto update command or something similar?




Aucun commentaire:

Enregistrer un commentaire