mercredi 16 novembre 2016

Excel VBA multi-chechbox control on userform

I'm confused about checkbox controls on userforms. I have to control the values of all checkboxes in my form and take actions depending on the values.For example, If cb(checkbox) 1,2 and 3 are True then excel will do action A. If cb 2,4 and 5 are True then excel will do action B and so on...

enter image description here

How can I control multiple checkbox values without so many if statements?




Aucun commentaire:

Enregistrer un commentaire