View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
MSweetG222 MSweetG222 is offline
external usenet poster
 
Posts: 158
Default respond to message box

Avencia,

I am not familiar with solver, but this might be the answer (place it at the
top of your subroutine) ...

Application.DisplayAlerts = False

Hope it helps.
--
Thx
MSweetG222



"Avecina" wrote:



I have written a code to solve an equation in excel visual basic. Every time
the sover windows appear I have to click OK for the rest of the macto to
continue. What command I can use to press OK automatically in the message box