View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] tkt_tang@hotmail.com is offline
external usenet poster
 
Posts: 92
Default Re : Excel CheckBoxes to be activated by VBA

1. Enters an Excel worksheet.

2. There's a CheckBox located in each of the cells along the range of
A1:A100 ; the CheckBoxes are respectively linked thereof.

3. The worksheet calculation mode is set to Mannual (for obvious
reason).

4. Then, the range (A1:A100) is updated and to be duly reflected by
the tick-marks (or the lack of it thereof) in the CheckBoxes.

5. How could the CheckBoxes be (exclusively) activated (as a selected
group) to reflect upon the renewed state of the pertinent range
(A1:A100) via VBA coding ?

6. Please share your experience.

7. Regards.