Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have created a little calculator that caclulates the values of
different parameters if I want to achieve a goal e.g. want to have total costs = 0. This is done by using Excel Solver. I want to create a User Form with many click boxes (number equal to the number of chaning parameters in the calculator) where the user will have the choice to choose which parameters will be included in the Solver by clicking in the appropriate box. The problem is how I write a macro that I can link to the Solver Macro where the "changing cells" in the latter change according to the choices that the user has made on the form. I hope it makes sense what I want to do and I hope there is a solution to it. Many thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Solver as User Defined Funcntion | Excel Worksheet Functions | |||
Trigger Excel Solver by User Defined Function | Excel Programming | |||
Solver in a User-Defined Function | Excel Programming | |||
How to: User Form to assign a user defined range to a macro variab | Excel Programming | |||
changing nested if statements into a user defined function | Excel Programming |