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 Cell Event Handler

in the worksheet_change event, you would test what cell triggered the event
and jump out if it isn't the cell of interest


at the top, add a line like:
if target.Address < "$F$4" then exit sub

so the event always fires, but it doesn't do anything unless it is the cell
you want to react to.

--
Regards,
Tom Ogilvy

David wrote in message
...
I would like a VBA macro to run after one cell has been updated or changed

and only that one cell. I've been able to write an Event Handler for the
worksheet change. The the macro runs great, but it runs all the time. I
just want to run it when a single cell on the spreadsheet is changed.

Thanks in advance for any help,

David