View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeffrey[_8_] Jeffrey[_8_] is offline
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.