+ Reply to Thread
Results 1 to 7 of 7

Disable Solver Result Dialog Box & Display Result in Cell

  1. #1
    Registered User
    Join Date
    06-18-2010
    Location
    Tokyo
    MS-Off Ver
    Excel 2013
    Posts
    17

    Disable Solver Result Dialog Box & Display Result in Cell

    Say, I will run solver for 10 cases, while running the 10 cases, I do not want to be paused by the result dialog.

    I found some relevant codes but not sure how to make sure of it yet.

    Please Login or Register  to view this content.
    Instead of popping out message box when solution cannot be found, I want the solver to continue until the end and display the result codes of all the cases in certain cells, like below:

    Case01: 0
    Case02: 0
    Case03: 4
    ...
    ...
    ...

    So that I can go back to the cases which give me result code from 3 onwards; ie those without solution.

    Please Login or Register  to view this content.
    Thanks.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Disable Solver Result Dialog Box & Display Result in Cell

    Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

    Read this to understand why we ask you to do this

    Cross posted at Code Cage Forum

    http://www.thecodecage.com/forumz/me...sult-cell.html
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Valued Forum Contributor
    Join Date
    05-14-2009
    Location
    gold coast
    MS-Off Ver
    Excel 2007
    Posts
    843

    Re: Disable Solver Result Dialog Box & Display Result in Cell

    Hello,

    if you intend to post the same thread accross diffrent forums,

    can you place a link to the threads put up at the other forum here so people dont waste their time if the question has aready been answered.

    thank you.


  4. #4
    Registered User
    Join Date
    06-18-2010
    Location
    Tokyo
    MS-Off Ver
    Excel 2013
    Posts
    17

    Re: Disable Solver Result Dialog Box & Display Result in Cell

    Sorry about that but I intend to update all the posts when it is solved, just like I have done lately.
    Thank you.

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Disable Solver Result Dialog Box & Display Result in Cell

    What you intend to do doesn't stop members possibly wasting their time on solved problems. Read the Forum rules & the link about why cross posting is generally unacceptable.

  6. #6
    Registered User
    Join Date
    06-18-2010
    Location
    Tokyo
    MS-Off Ver
    Excel 2013
    Posts
    17

    Re: Disable Solver Result Dialog Box & Display Result in Cell


  7. #7
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Disable Solver Result Dialog Box & Display Result in Cell

    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

+ 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