I need to fire a Worksheet_Change event when a cell value changes.
The problem is the value is changed using a "data validation" drop-down and so the change in cell value does not fire the event.
Any ideas of a workaround or solution?
This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or distribution of the material in this e-mail is strictly forbidden.