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?