jeudi 29 septembre 2016

vba hierarchical check boxes

I have the following sample for a case I am trying to implement

http://ift.tt/2dvdjVe

I have cat1, Cat 2 & cat 3, with sub categories under each. When the user selects or un-select this category on DRG summary sheet, its corresponding instances on DRG Target should get selected. (I still haven't got to the part where the opposite should work, so if one or more child category are selected, the parent gets selected. Ideas for that are appreciated)

I have a flag for this, which is being updating but only when I manually run the macro. I want to be able to call the macro from a change event. Any suggestions?




Aucun commentaire:

Enregistrer un commentaire