VBA Code to auto-click OK in Excel

Question

I have made an Excel macro that gives results using solver. After the result is generated it displays a dialogue box to accept the result. As I have 50 solver results in the macro, I have to click OK 50 times.

Is there some tweak in VBA that can be done to automatically click OK or press enter?

Why not just take the dialogue box out of the code? Just put the solver data into a sheet or something. Why have a box pop up if you just want to automatically clear it? — Chrismas007
– Chrismas007, Commented Dec 8, 2014 at 15:16
The dialogue box is not generated by me in VBA. It is the result display of excel solver that is implemented in the macro. Please help me with sendkeys command. — Achintya Paradkar
– Achintya Paradkar, Commented Dec 13, 2014 at 15:15

shir · Accepted Answer · 2015-10-01 13:13:55Z

6

there is an easier way. type this in your code: "solversolve(true)" True makes solver return the results without displaying the Solver Results dialog box

answered Oct 1, 2015 at 13:13

shir

611 silver badge2 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Darren Bartrup-Cook Over a year ago

SendKeys, DisplayAlerts - MSDN says to use SolverSolve ( msdn.microsoft.com/en-us/library/office/ff197237.aspx ). Can even execute another macro rather than display the solution form - why wouldn't you use this method?

Achintya Paradkar · Accepted Answer · 2014-12-13 16:16:30Z

2

SendKeys "~" did the work for me. Type this code after the solversolve command and enter gets automatically typed pressing OK and closing the box.

answered Dec 13, 2014 at 16:16

Achintya Paradkar

511 gold badge1 silver badge7 bronze badges

Comments

Will Rickards · Accepted Answer · 2014-12-08 14:52:12Z

0

There is a SendKeys command in vba. This allows you to simulate keystrokes.

answered Dec 8, 2014 at 14:52

Will Rickards

2,8112 gold badges20 silver badges25 bronze badges

Comments

jordanz · Accepted Answer · 2022-12-04 15:23:26Z

-1

Not sure, but try Application.DisplayAlerts

That is, modify your macro:

Application.DisplayAlerts = False    'turns off dialog prompts

your_macro_code_here

Application.DisplayAlerts = True     'turns back on dialog prompts for normal usage

edited Dec 4, 2022 at 15:23

jordanz

3734 silver badges13 bronze badges

answered Dec 8, 2014 at 15:07

Bryan M

113 bronze badges

1 Comment

Chrismas007 Over a year ago

While this is an "answer" it is typically good to give reasons why or sources to back up answers instead of "not sure" guesses.

Collectives™ on Stack Overflow

VBA Code to auto-click OK in Excel

4 Answers 4

1 Comment

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related