mercredi 16 mars 2016

Default Creating Hierarchy / Levels with CheckBoxes (Form Control)

I posted this in Mr. Excel Website but no response yet. here is my question.

Hi & Attention all MVPs I got a situation here.

I am trying to create a Hierarchy in check boxes. My example file is here

http://ift.tt/21uWL0r

I have check boxes for different levels e.g. Lowest level is "Sub Division" then "Division" then "Oil Sector Business" or "Gas Sector Business" then Company as a whole. Please have a look at the attached sheet. i want to link these check boxes so that if i select a division, then all sub divisions within that division are selected. Likewise if i select Oil Sector then all divisions and sub divisions in Oil Sector selected.

By selected i mean True.

Any help or ideas will be appreciated.




Aucun commentaire:

Enregistrer un commentaire