View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default Knowing when Solver closes

William,

Don't use the dialog. Instead, control how the interaction between your user and solver progresses.
See

http://support.microsoft.com/kb/843304

for details, as well as the examples in VBA help.

HTH,
Bernie
MS Excel MVP


"William Benson" wrote in message
...
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?