Hi All,
I've created an excel as attached.
1. to check the checkbox on cell B3 then C3:E3 will be selected, uncheck it to de-select C3:E3.
2. to check the checkbox on cell B4 then C4:E4 will be selected, uncheck it to de-select C4:E4.
3. to check the checkbox on cell B6 then checkboxes B3 and B4 will be checked automatically, thus C3:E3 and C4:E4 will be selected, uncheck it then all checkboxes will be unchcked.
4. to click "Clear" button on B8, then clear all values of the selected cells; no effect if checkboxe B3 or B4 is not not selected.
But how to do this? Thanks!
Bookmarks