OpenSolver with UDF

Hello,

I am trying to use OpenSolver with a user defined function. please see below rthe VBA code

I have a number of problems:

1. How do I define a stoping criterion, other than maximum number of iterations? For example I would like to have a constraint on the goal, like goal<0,goal>-10.
2. While in the UDF, I want to update the worksheet with some information. It seems that the access to the sheet from a place other than the algorithm itself is blocked. No updates from th UDF but I do see updates of the goal value and variables
Is there a way to allow the UDF to update the sheet?

Thank you

Please Login or Register  to view this content.