multiple data validation selections - problem when manually editing

[david763]

Hi, same issue as thread here but no resolution.
VBA - Distinguishing when a cell is edited by a data validation list or free fromat text entry

I have VBA code to allow multiple data validation settings - working well except when it doesn't work at all (separate issue from this).

Turning off the error alert allows the previous entries to be edited (for example, when i just want to remove ONE previous entry). When i edit in cell, the result is that ALL existing entries are appended to the list again.

I need some code that appends selections from the drop down list as designed, but also allows for in cell edits without re-appending the whole list again.

Does this make sense?

Can anybody help?

Thanks

 

[AlphaFrog]

I don't know of a way to determine a drop down change from a manual edit with VBA code. A work-around would be to have a macro to disable Events when you want to edit a cell. Run the macro before you edit the cell to disable events, and run it again after you edit a cell to re-enable events.

Sub Toggle_Events()
    Application.EnableEvents = Not Application.EnableEvents
End Sub

Assign it to a short cut key or button to make it easier to toggle.

Not a perfect solution, but it's all I've got.