Can anyone help with on click code?

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

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)
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
 
I think more people would be willing to respond if you post the portion of code
that's causing the trouble (not a workbook).

Sometimes when you leave too much to the imagination, there's just too much
setup involved to take a guess at.
 
Back
Top