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?
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?
The worksheet change function can only change cells on the worksheet were the changge was made. If you are changing a cel in a different sheet it won't work in 2002 but would work in earlier versions of excel.
|
