Functions inside Solver algo

[Zward25]

Hey guys, I have an array of quantities in my VBA code that i want to change to maximiaze a value. I am having trouble incorporating the VBA function into the solver methodology. I am currently copying these the quantities back and forth from the function to the worksheet and then clicking a button that solves the worksheet values by calling the function..... only it doesn't work yet!

Part of below is pseudo code:

Please Login or Register  to view this content.

Inside RunVBAFunction it sets the worksheet values to the array that is used in RunVBAFunction. It also then prints out a formula and value to the "A1" cell that is being maximized. The function runs correctly and spits out a value correctly to the workshet... but it is only called once though, and no itterative process occurs. I also tried putting this solver process in a loop but there was not maximination going on.

Please help, thanks in advance!!!

[shg]

Welcome to the forum.

Please take a few minutes to read the forum rules and then edit your post to add code tags.

Thanks.

[Zward25]

Hey guys, I have an array of quantities in my VBA code that i want to change to maximiaze a value. I am having trouble incorporating the VBA function into the solver methodology. I am currently copying these the quantities back and forth from the function to the worksheet and then clicking a button that solves the worksheet values by calling the function..... only it doesn't work yet!

Part of below is pseudo code:

Please Login or Register  to view this content.

' Inside RunVBAFunction it sets the worksheet values to the array that is used in RunVBAFunction. It also then prints out a formula and value to the "A1" cell that is being maximized. The function runs correctly and spits out a value correctly to the workshet... but it is only called once though, and no itterative process occurs. I also tried putting this solver process in a loop but there was not maximination going on.

Please help, thanks in advance!!!

[shg]

Threads merged.

Second request, Zward -- please read the forum rules, and then edit your post to add code tags.

[Zward25]

Hey I'm reading the rules... I've highlighted my code. I don't see this # that tags the code.

[martindwilson]

go advanced, the option is there

[Zward25]

I am not sure what you mean by 'go advanced'. There is an option to add a function/procedure into one's SolverSolve? ?

[shg]

Click the Edit button on your post.

Click the Go Advance button.

Select the code in your post.

Push the button with the octothorpe (#).

[shg]

Thank you.

but it is only called once

Yes indeed, you are only calling it once each time DoSolver runs.

If you want to call it more than once, you need to put a loop around it in your code.