Call 2 macros with listbox change

I want to execute two macros every time a listbox change event takes place...it will be the same two macros every time a different item is selected in the listbox. Based on what is selected in the multicolumn listbox, one macro copies data from the listbox range and passes it to multiple text box values. The other macro runs a Solver with this data. For some reason, the code only works when I select an item in the listbox for the first time. When I change the selected listbox item, nothing happens. Here is my code and thanks in advance for any help you can provide:

Please Login or Register  to view this content.

If I remove the Call Solver_Vs from the code, the Copy macro works fine when the listbox selection changes any number of times. If I create a command button to call the Solver_Vs, it will perform as desired every time I click the command button. So this makes me believe something is wrong in my For & if statement. Thoughts?

As requested. Thanks for the prompt response.

Please Login or Register  to view this content.

Figured I would go ahead and paste the Solver macro as well:

Please Login or Register  to view this content.

Thanks for the help, but I still have the same issue. If I remove the Call Solver_Vs, the listbox1 change procedure works fine. However with the call Solver_Vs added to the procedure, the textbox values as well as the Solver_Vs will only work for the first initial selection in the listbox. When I change the selection which changes values for the Solver_Vs, the textboxes do not update, and it appears that the solver runs again with the original parameters as opposed to the newly selected.

I wonder if this is a solver problem or a listbox problem. Perhaps you could upload the file with listbox macro and solver model?

Alf

Please see attached.

I'm still having the same issues, if you care to drop some knowledge.

I've had a look at your solver macro and the thing I find strange is the constraint you set for B16 i.e. >= 0 and <= 1000 but as B16 is not a cell that solver can change these constraints are
meaningless.

So if you canged

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

then solver would be able to change B16 and testing I got a value of 0,406325304 for B16 but B15 changed from 0,406324303680428 to -0.0000010 so perhaps this is not the best of ideas.

Sorry I could not be more helpfull.

Alf