I Need Help Please

[kekyeah]

I am using MS Excel and i am trying to make a button where i can click to run the 'solver' function thats is built in ino the program but I am not very good with VB so i dont know how to code the button. BTW, the solver function is an add-on for excel which is located under the tools tab. please help me. thanks.

[MartinLiss]

Welcome to VB Forums!

I moved your thread to here since it looks like you are working with VBA rather than VB. I'm sure someone will help you.

[RobDog888]

This button you want, is it a button on the actual sheet or a toolbar button?

[lintz]

I've added the Solver add-in and it appears under the Tools menu but I don't think (well I couldn't find) a toolbar button for it.

Another option is to run a macro of a problem you want to solve and then look at the saved macro to see how it is done with code.

HTH

[RobDog888]

Oh, that solver addin. The one that comes with Excel. Isnt it invoked from code only?

[RobDog888]

Ok, here one way to invoke the Solver addin.

Dim oCBmnuTools As Office.CommandBarPopup
    Dim oCBmnuSolver As Office.CommandBarButton
    Set oCBmnuTools = Application.CommandBars("Worksheet Menu Bar").Controls("&Tools")
    Set oCBmnuSolver = oCBmnuTools.Controls("Sol&ver...")
    oCBmnuSolver.Execute