I use drop-down validation lists in numerous of my spreadsheets and they
seem to fire the "worksheet_change" event just fine (Excel 2000).
----- Original Message -----
From: <[log in to unmask]>
To: <[log in to unmask]>
Sent: Monday, March 05, 2001 4:53 AM
Subject: SV: Worksheet_Change event not fired when cell value is changed usi
ng validation drop-down
I think you need to include the event Worksheet_Calculate.
Fren: [log in to unmask] [mailto:[log in to unmask]]
Skickat: den 5 mars 2001 13:47
Till: [log in to unmask]
Dmne: 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.