Validation not triggering Change event in Excel XP

[Jeffrey]

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.aspx?scid=kb;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.

 

[Peter Huang [MSFT]]

Hi Jeff,

Based on my research, this problem has been fixed from Excel 2000.
Can you provide a simple reproduce xls file together with the test code?
So that we can try to reproduce at our side.

You can reach me via removing "online" from my email address.
Thanks!

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Jeffrey]

Thanks for sending me the test.xls file. It appears to work as you intended.

However, my workbook still does not work correctly. You pointed out that I
can set a breakpoint inside the subroutine that should be executing, and run
the code step-by-step. This is true, but that's the ONLY way the code will
execute. If you remove all breakpoints and trigger the change event
normally, the SetOptionsToParetoAlternative won't do what it's supposed to do.

Thanks,

Jeffrey

 

[Peter Huang [MSFT]]

Hi

It is strange, based on my test, even I put breakpoint and the
SetOptionsToParetoAlternative will run, but it seems that the cells is not
changed.
So I just wonder maybe the logic may not correct.
So far I think you may try to create a new workbook and add the code one
by one to see what code line may cause the problem.
Thanks!

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.