Hello,
I put "Data Validation" element on my Sheet - Data validation based on LIST i.e. list of A1:A20 cells.
And accodring to selected item I would like to change the color of cell in ValidationListComboBox. I am using
Sub Worksheet_Change(ByVal Target As Range) to catch the event ValidationListChange. However, there
is a small problem. Worksheet_Change catching me ALL events e.g. column insertion, column deletion,
text insertion etc. How can I recognize, that Worksheet_Change cought just right the "Validation List Changed"
event ??? Is it possible to obtain this info from "ByVal Target As Range" ??? How can I Identify source of Event ?
Many thanks.
Bookmarks