Re : Excel CheckBoxes to be activated by VBA

[tkt_tang]

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.

 

[Tom Ogilvy]

If the cells are linked to the checkboxes and you alter the value of the
cell, the checkboxes should be updated automatically.

 

[tkt_tang]

Mr. Tom Ogilvy,

Thank you very much indeed for responding to the query.

Upon altering the value of the cells, the corresponding CheckBoxes
should be updated automatically ; however, the worksheet calculation
mode is set to Mannual (for obvious reason).

When ActiveSheet.Calculate is applied,
the CheckBoxes will be updated and so will the re-calculations of a
relatively large collection of (HyperLink) formulae thereof.

As it turns out, the HyperLinks would not require re-calculations (and
hence, it should be profitable to save the noticeable time delay
expended on the non-essential activity).

Attempted but in vain, to effect a local calculation of,
ActiveSheet.Range("A1:A100").Calculate
(to which the CheckBoxes are linked and residing),
(contrary to such claims with reference to MS-Help ; sigh).

Please extend your recommendation with further move next.

Regards.