Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel VBA Macro stops running when another program is activated | Excel Programming | |||
message/dialog box auto open when excel file is activated | Excel Discussion (Misc queries) | |||
Excel cannot complete ......... when screen saver is activated. | Excel Programming | |||
Restrictions on Excel in-place activated in Browser? | Excel Programming | |||
Recalculating Excel Sheets with activated autofilter | Excel Programming |