ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   2002: Worksheet_Change and Validation error (https://www.excelbanter.com/excel-programming/435950-2002-worksheet_change-validation-error.html)

Smallweed

2002: Worksheet_Change and Validation error
 
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?



All times are GMT +1. The time now is 05:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com