Here's the problem I am facing...
I have written a macro for Excel Solver, where I have pre-defined the "changing cells" for the Solver (as I would...). As this calculator is going to be used by other people, I would like ideally to write a macro that gives them the possibility to define themselves which cells should be included in the "changing cells" for the solver. I am thinking of adding "checkboxes" on the spreadsheet next to each parameter that can be included in the solver, but then I don't know if there is anyway of incorporating a nested "if statement" in the Solver macro...complicated...I hope this makes sense. Thank you...
I have written a macro for Excel Solver, where I have pre-defined the "changing cells" for the Solver (as I would...). As this calculator is going to be used by other people, I would like ideally to write a macro that gives them the possibility to define themselves which cells should be included in the "changing cells" for the solver. I am thinking of adding "checkboxes" on the spreadsheet next to each parameter that can be included in the solver, but then I don't know if there is anyway of incorporating a nested "if statement" in the Solver macro...complicated...I hope this makes sense. Thank you...