Hello,

I'm attempting to solve a linear programming problem using Excel's Solver. Now the thing is that it's a fairly complex problem which would also require some back-end VBA programming.

I started working on it and I realised that I'm assuming something which if not true would render my program useless. So my question is:

While Excel runs its Solver to find a solution to my LPP, does the event Worksheet_Event get executed for the worksheet which contains the variable cells? In other words, in the process of determining a solution, does Solver try fit in values in the variable cells to get an optimised solution?

I'd be grateful to anybody who could help me out.

Thanks in advance.

Also, could anyone suggest some online resources which would help me using Solver and its programming aspects?