I have come across a strange VBA behaviour. I have set up a worksheet_change routine that attempts to put a date in the adjacent cell and the move to another cell. The cell being changed has a data validation list of percentages. The worksheet_change uses target.offset(0,1) = date and then range(“cell address”).select to move to the other cell.
However I have found this works just fine if I manually enter a valid % in the cell but it ignores the range.select (or at least that doesn’t have any effect) if I change cell value using the DV drop down list. I also notice that my VBA breakpoints and stop commands are ignored when using the DV dropdown value selection - they are irk just fine if I manually enter a correct value.
I’m using O365.
Hope someone out there can help.
Thx
Max
However I have found this works just fine if I manually enter a valid % in the cell but it ignores the range.select (or at least that doesn’t have any effect) if I change cell value using the DV drop down list. I also notice that my VBA breakpoints and stop commands are ignored when using the DV dropdown value selection - they are irk just fine if I manually enter a correct value.
I’m using O365.
Hope someone out there can help.
Thx
Max