Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Macro for Solver with user defined changing cells

I have created a little calculator that caclulates the values of
different parameters if I want to achieve a goal e.g. want to have
total costs = 0. This is done by using Excel Solver.

I want to create a User Form with many click boxes (number equal to
the number of chaning parameters in the calculator) where the user
will have the choice to choose which parameters will be included in
the Solver by clicking in the appropriate box.

The problem is how I write a macro that I can link to the Solver Macro
where the "changing cells" in the latter change according to the
choices that the user has made on the form.

I hope it makes sense what I want to do and I hope there is a solution
to it. Many thanks.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Solver as User Defined Funcntion Murthy Excel Worksheet Functions 11 March 3rd 07 08:16 PM
Trigger Excel Solver by User Defined Function Murthy Excel Programming 0 March 2nd 07 11:29 PM
Solver in a User-Defined Function Pflugs Excel Programming 4 July 14th 06 11:27 PM
How to: User Form to assign a user defined range to a macro variab TrevTrav Excel Programming 1 March 22nd 05 07:57 PM
changing nested if statements into a user defined function Rob Slagle Excel Programming 3 July 23rd 04 07:04 PM


All times are GMT +1. The time now is 02:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"