| 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. |
| 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 | |||
Threaded Mode
