I too have been having the exact same problem with this Excel bug where
the Worksheet_Change event is not firing properly when data validation
cells are changed. I cannot even begin to tell you all how many hours
of grief it has caused me!!!! Can we say class-action lawsuit!?! ;)