PDA

View Full Version : Trigger Excel Solver by User Defined Function



murthy_v_s
03-02-2007, 01:45 PM
Hello all:

Can anyone please let me know how can I generate a user defined function(UDF) that triggers excel's solver?
I have a set of 5 constraints and one objective that is to be maximized. I want to perform a senstivity analysis for my objective changing these 5 constraints. So I want the UDF to take all the 5 constraints and return me the optimized value (obtained from excel's solver) for the objective cell.
I appreciate your help in this regard.

Thanks.

XLGibbs
03-03-2007, 10:24 AM
http://vbaexpress.com/forum/showthread.php?t=11715

Thread locked. Duplicate above with responses and crossposts.