View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Change Cell from Validated List Not Firing Worksheet Change Event

This would describe Excel 97. You should get a change event in later
versions.

--
Regards,
Tom Ogilvy

" wrote in message
oups.com...
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?