Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have code that dynamically creates a checkbox on each new line added to a
worksheet (i.e. Activesheet.Checkboxes.Add statement is executed in the Worksheet_Change event) and each newly created checkbox is linked to an underlying cell. However, once these dynamically created checkboxes are placed on the form, I don't seem to have any means of capturing clicks on them. Even though when I click the checkbox, the value in the LinkedCell changes accordingly, the Worksheet_Change event is not triggered. There is no Checkbox_Click for me to code to since they're created on the fly. Anyone have any idea how I can capture the clicks on these checkboxes? Thanks, Mark D. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Capturing excel insert/delete events. | Excel Worksheet Functions | |||
Capturing Insert/Delete Events in Excel Sheet using c# | Excel Worksheet Functions | |||
Capturing Top 5 Performers | Excel Worksheet Functions | |||
capturing all of the data | Excel Worksheet Functions | |||
How to have Checkbox A uncheck with checked Checkbox B | Excel Discussion (Misc queries) |