View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
William Benson[_3_] William Benson[_3_] is offline
external usenet poster
 
Posts: 27
Default Knowing when Solver closes

I am launching solver via a command button which uses SendKeys to invoke the
dialog. I cannot control what the user does with solver and I don't want to.
What I do need, is some way to "know" the very instant that they close the
Solver dialog. The closest I can get is the Worksheet_SelectionChange, and
it is not good enough. Can someone recommend something I can do from API
perhaps? Some condition I can test on a timed basis maybe?