LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Can anyone help with _click() events?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
events? [email protected] Excel Discussion (Misc queries) 1 September 14th 05 03:26 PM
Events ojv[_2_] Excel Programming 3 October 22nd 04 01:59 PM
events jacob Excel Programming 2 September 7th 04 02:15 PM
Need some events... Tim Mattingly Excel Programming 0 August 16th 04 09:53 AM
events Mark[_17_] Excel Programming 1 October 31st 03 09:18 AM


All times are GMT +1. The time now is 08:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"