Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm trying to display a form that cycles through a list of items and
displays checkboxes that are ticked or unticked depending on the item properties. I have written code that uses the _click() event to determine if the status has changed (ie someone has ticked what was previously unticked / vice versa) and then retrieve via an inputbox some more details which are then inserted into the sheet. HOWEVER, what seems to happen is that Excel is recognising the cycling of items as being _click events and pops up the box for input whenever the checkbox moves from unticked to ticked because the item it refers to has that property even if you haven't clicked on the actual checkbox. Am I missing something fundamental? Any help gratefully received. Peter |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
events? | Excel Discussion (Misc queries) | |||
Events | Excel Programming | |||
events | Excel Programming | |||
Need some events... | Excel Programming | |||
events | Excel Programming |