+ Reply to Thread
Results 1 to 1 of 1

macro solver changing cells

  1. #1
    Registered User
    Join Date
    04-14-2013
    Location
    singapore
    MS-Off Ver
    Excel 2010
    Posts
    14

    macro solver changing cells

    Hi, here is my problem:
    Capture.PNG

    I need a macro linked to solver so when I click on one button, it will converge input value to target value by changing cells in two cases
    case 1: seek a solution by changing A,B,C,D, constraint is 100% in cell C4
    case 2: seek a solution by only changing C & D, keep A & B fixed. constraint is 50% in cell C4 (sum of C & D).
    The problem is the input value is the sumproduct of A,B,C,D so how can I let 2 variables on float while the other 2 fixed?

    here is my macro:
    Please Login or Register  to view this content.
    one solution I think of is creating a msgbox pop out to prompt me enter the cells to be changed, like the original solver which I can select the changing cells but I can I do that?
    is there any better solution?

    Thanks a lot!!!
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1