How do I Assign Solver to a Command Button in VBA

**shuxin** · 09-19-2021, 10:38 PM

Hello, I'm trying to assign the solver function to a command button in VBA but it says there is an error. I recorded macro and pasted my solver code under the command button but it results in an error. How do I correct this please?

Please Login or Register  to view this content.

**Hydraulics** · 09-20-2021, 07:35 AM

Have you added a reference to Solver in your VBA project?

You can delete the double instructions, and use

Please Login or Register  to view this content.

HTH,

Francesco

**Alf** · 09-20-2021, 08:29 AM

Identical problem, different name. Cross post?

https://www.reddit.com/r/excel/comme...ess_a_command/

Alf

**6StringJazzer** · 09-20-2021, 11:21 AM

shuxin

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

Thanks to Alf for providing the link.

How do I Assign Solver to a Command Button in VBA

LinkBack

Thread Tools

Rate This Thread

Display

How do I Assign Solver to a Command Button in VBA

Re: How do I Assign Solver to a Command Button in VBA

Re: How do I Assign Solver to a Command Button in VBA

Re: How do I Assign Solver to a Command Button in VBA

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to assign the form in the command button.

[SOLVED] Assign a macro to a command button

Assign macro to command button

Solver not running with command button

Can't Assign Macro to Command Button??

Assign MAcro to command button

Assign Macro to Command Button

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions