View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg Glynn[_4_] Greg Glynn[_4_] is offline
external usenet poster
 
Posts: 6
Default Excel/MSQuery - Detect when Refresh has occured

Hi Everyone,

I've got an ODBC Query which is set to automatically refresh if the
selection criteria cell (to which it is linked) changes.

Is there a way to programatically detect that the refresh has occured?
I need to update another cell after any refresh.

Perhaps I need only to detect if the selection criteria cell contents
has changed.

If anyone can suggest either solution, that would be great.

Regards


Greg Glynn