VBA - Distinguishing when a cell is edited by a data validation list or free fromat text e

Hi All,

Does anyone know of VBA code which can distinguish whether a cell has been edited by:

selecting an option from a data validation list (DVL)
or
manually editing the text in a cell?

The ""Show error alert after invalid data is entered"" option is unticked to allow both selection from the DVL as well as free format text entries.

The problem arises when using the code below which makes an edited cell within a range display the new value as well as the prior value(s). This works well when using the DVL but not when editing the cell.

Is there any code which can distinguish between the 2?

Hope this makes sense, please let me know if anything requires further clarification.

Many thanks in advance
JLD

Please Login or Register  to view this content.

There's more to that code, isn't there? A worksheet_selectionchange event, too?

Meanwhile, I don't see any reason why that code doesn't work with manual entries, too. It does for me.

On the DEveloper tab you could click the DESIGN MODE icon to turn off events so you can freely edit your cells without the event triggering, and then turn off Design Mode to set things working again.

I've marked this thread as SOLVED for you.
Next time, select Thread Tools from the links above to mark a thread as SOLVED. Thanks.