Crash Using Watch Window XL2000

  • Thread starter Thread starter Alex J
  • Start date Start date
A

Alex J

All,
Had a very curious event occur today.

Selected Worksheet_Change event macro on a sheet and put
breakoint on its title line.

Added a Watch expression for Application.EnableEvents, All
procedures, All modules.

Made a change on the sheet (using a cell with Validation).

Result:
EXCEL VANISHED! No errors, no warning, nothing.
I am not dreaming - this is repeatable!

Have done a Google serach and a MS KB search with no hits.
Any thoughts from the MVP community?
(besides of course, DON'T DO THAT!)

Thanks for you help,
Bewildered (Alex J)
 
Note:
More Testing indicates that the problem ocurs without the
watch in place - some confilict between validation and the
breakpoint on the event processing code?
Alex J
 
Alex

I couldn't reproduce it. XL2000 on Win98SE, data validation with list in
A1, change event with breakpoint on Sub line and one line below for a
message box.

Result is that the VBE is opened and in debug mode on the breakpoint.
 
Dick,

Found the cause and worked around it. Has to do with a dynamic range
(calculated with a VBA function using application.volatile) being declared
as a range variable in the Worksheet_Change function. There is some error in
the function which causes the crash.

Since the problem has nothing to do with the title of the thread, I will
stop this thread and start another with more accurate information for the
group.

I must say, though, I have never seen XL2000 go completely t-ts up and
dissapear like this before. I must have hit the motherlode of critical
errors.

Thanks a lot for your response,

Alex J
 
Back
Top