E
Erik
Hi
I experience a problem with a worksheet that worked fine in 2000, yet
in excel 2007 it generates a problem
I have localised the problem yet do not know the cause/solution
This is the problem:
when I select a cell containg a validation list ("drop down list") and
when I let some action follow through excel's worksheet_change
property (VBA) it generates a 1004 error the moment this same sub
starts writing to a cell (any cell)
The strange thing is: when I manually change the validation list to a
different value (that means: I enter and type in one of the possible
values the validation list allows) everything works flawlessly
So in fact excel 2007 generates the problem only when I change the
value of a cell with validation list by picking from drop-down list
*and* let some write action follow in worksheet_change
When I manually enter the new value, it works as expected
please! Any any suggestions on how to solve this
It appears to me as an excel bug
kind regards
erik
I experience a problem with a worksheet that worked fine in 2000, yet
in excel 2007 it generates a problem
I have localised the problem yet do not know the cause/solution
This is the problem:
when I select a cell containg a validation list ("drop down list") and
when I let some action follow through excel's worksheet_change
property (VBA) it generates a 1004 error the moment this same sub
starts writing to a cell (any cell)
The strange thing is: when I manually change the validation list to a
different value (that means: I enter and type in one of the possible
values the validation list allows) everything works flawlessly
So in fact excel 2007 generates the problem only when I change the
value of a cell with validation list by picking from drop-down list
*and* let some write action follow in worksheet_change
When I manually enter the new value, it works as expected
please! Any any suggestions on how to solve this
It appears to me as an excel bug
kind regards
erik