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

Please post your code.

"Erik" wrote:

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