View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] marston.gould@alaskaair.com is offline
external usenet poster
 
Posts: 102
Default Change Cell from Validated List Not Firing Worksheet Change Event

I have a cell whose valid values are limited through a validation list
(using a named range).
The cell uses the excel pull down feature.
When I make the change through the pull down, no worksheet change event
is fired, but
when I make the change by typing it does.

Is there a way to get around this so that I can find the change when it
occurs from changing a value through the pull down list?