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.

Re : Excel CheckBoxes to be activated by VBA
 

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

--
Regards,
Tom Ogilvy


" wrote:

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.

Re : Excel CheckBoxes to be activated by VBA
 

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.