Runtime-error 1004 (excel 2007) when selecting validation list optiontriggering worksheet_change property
 

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

Runtime-error 1004 (excel 2007) when selecting validation list opt
 

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