I think you need to include the event Worksheet_Calculate.
Från: [log in to unmask] [mailto:[log in to unmask]]
Skickat: den 5 mars 2001 13:47
Till: [log in to unmask]
Ämne: Worksheet_Change event not fired when cell value is changed using
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.