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: 3
Default Validation not triggering Change event in Excel XP

I've developed a workbook in Excel XP that exhibits a strange problem.
There are several cells which have data validation lists. However, only
some of the validated cells trigger the Worksheet_Change event. What's
even stranger is if I insert a breakpoint inside the Worksheet_Change event
and then change one of the validated problem cells, the event triggers and I
can step through my code.

There's a KB article about a similar issue
(http://support.microsoft.com/default...;en-us;172832), but it's
specifically about Excel 97. Can anyone from Microsoft see if this bug was
ever worked on? Based on my experience, I'd say it wasn't completely
resolved.
 
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
Validation not triggering Change event in Excel XP Jeffrey[_8_] Excel Programming 1 March 8th 06 01:59 AM
Triggering an event based on reference Supriya Excel Programming 0 January 29th 04 11:50 AM
auto-filter change not triggering worksheet_change event mark Excel Programming 1 September 19th 03 03:01 PM
Triggering click event of a menu in vba steve Excel Programming 4 August 19th 03 06:17 PM
Triggering click event of a menu in vba Tom Ogilvy Excel Programming 0 August 18th 03 07:51 PM


All times are GMT +1. The time now is 03:50 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"