I would like to create a command button that would open solver constraint dialogue dox. Kindly assist.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
command button
0
Answers
0
You can't do it with a button in the worksheet but you can add a button to the Quick Access Toolbar and that at least makes it easier than before.
Go to the Solver button in the Ribbon menu, right-click it and click Add to Quick Access Toolbar.