minimize or maximize non-linear problem in vba

[Houssame]

Dear Excel fam.,
I am trying to use the powerful solver tool in excel, to minimize a non linear function f(x,y,z) observing certain constraints say x-xy=A.
My question is : is there any way, I can loop through different values of A using vba and solver so as I generate two columns, one of the optimized function and the other of A. I don't know actually how to use solver (non-linear or even LP) through vba editor. Can anyone please help me ?
Thanking you in advance,
Best regards,

 

[BadgerRoad]

Are you able to set your problem up using the Solver interface in Excel? If so, then do that while recording the setup as a macro. You will then be able to look at the vba generated for Solver. If you then examine the vba code generated for Solver you should be able to figure out how to modify it to loop through different values.
Does that make sense?

 

[Houssame]

Dear BadgerRoad​

Thank you a lot for this quick answer. It actually worked !!!
Kind regards,
Houssame,

 

[BadgerRoad]

You are welcome. Glad it worked out.