View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Matthew Wieder Matthew Wieder is offline
external usenet poster
 
Posts: 48
Default Mimic Value Being Typed Into Cell

It's the OnEntry handler that has been setup by an add-in. Just
changing the cell value doesn't trigger the event, but I think a
combination of setting the activecell and calling the handler with Call
should do the trick...
thanks!

Tom Ogilvy wrote:
What event do you claim isn't being fired. Perhaps you have disabled
events, because the change event fires if the cell value is changed either
manually or by code. If you are using selection change, then you can have
your code select the cell if you need to fire the event.