2002: Worksheet_Change and Validation error

S

Smallweed

Hi, I know there was a problem in Excel 97 with Worksheet_Change not being
fired when using a data validation dropdown. However, this is a different
problem in 2002. I have code that logs at the top of the sheet the last
date/time the inputs were changed, triggered by the Worksheet_Change event.
It works fine if I type the change in a cell with data validation but if I
choose a value from the drop down list, the code bombs out at the line that
writes the date/time to the cell. There's no error message: the code just
stops. Is this a known bug? And is there a solution?
 
J

joel

The worksheet change function can only change cells on the workshee
were the changge was made. If you are changing a cel in a differen
sheet it won't work in 2002 but would work in earlier versions of excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Worksheet_Change after validation 7
bug: Worksheet_Change clashes with dropdown list validation. 4
Runtime-error 1004 (excel 2007) when selecting validation list optiontriggering worksheet_change pro 1
Create validation list with Worksheet_change 1
Getting Data Validation to execute when using Paste Special... Val 3
Combine Two Different Worksheet_Change codes 9
Worksheet_Change Woes 6
Run VBA code only worksheet change, but don't trigger worksheet_change event based on what the code 6

Top