Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying Combinations of Rows
I have written a macro to examine all possible combinations of rows and
determine which of these satisfy a specific criterion. Unfortunately, there are a number of potential solutions, so I need to examine each solution to figure out which is the one I want. The macro changes the color of the selected cells, calls MsgBox("Solution found") to let me examine the solution, and then continues on to the next solution when I click OK. I would like to scroll down the page to examine the solution, but nothing responds while the msgbox is being displayed. Any suggestions? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying Combinations of Rows
Application.InputBox("Solution found, Use Mouse to examine",type:=8) -- Regards, Tom Ogilvy "George B" wrote in message ... I have written a macro to examine all possible combinations of rows and determine which of these satisfy a specific criterion. Unfortunately, there are a number of potential solutions, so I need to examine each solution to figure out which is the one I want. The macro changes the color of the selected cells, calls MsgBox("Solution found") to let me examine the solution, and then continues on to the next solution when I click OK. I would like to scroll down the page to examine the solution, but nothing responds while the msgbox is being displayed. Any suggestions? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying Combinations of Rows
Thanks, Tom. But I notice that my help file (Excel 2000) does not list a
type parameter for InputBox. An undocumented feature? "Tom Ogilvy" wrote in message ... Application.InputBox("Solution found, Use Mouse to examine",type:=8) -- Regards, Tom Ogilvy "George B" wrote in message ... I have written a macro to examine all possible combinations of rows and determine which of these satisfy a specific criterion. Unfortunately, there are a number of potential solutions, so I need to examine each solution to figure out which is the one I want. The macro changes the color of the selected cells, calls MsgBox("Solution found") to let me examine the solution, and then continues on to the next solution when I click OK. I would like to scroll down the page to examine the solution, but nothing responds while the msgbox is being displayed. Any suggestions? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying Combinations of Rows
It's confusing, but there is an InputBox Function and an InputBox Method.
The latter accepts the Type parameter. -- Vasant "George B" wrote in message ... Thanks, Tom. But I notice that my help file (Excel 2000) does not list a type parameter for InputBox. An undocumented feature? "Tom Ogilvy" wrote in message ... Application.InputBox("Solution found, Use Mouse to examine",type:=8) -- Regards, Tom Ogilvy "George B" wrote in message ... I have written a macro to examine all possible combinations of rows and determine which of these satisfy a specific criterion. Unfortunately, there are a number of potential solutions, so I need to examine each solution to figure out which is the one I want. The macro changes the color of the selected cells, calls MsgBox("Solution found") to let me examine the solution, and then continues on to the next solution when I click OK. I would like to scroll down the page to examine the solution, but nothing responds while the msgbox is being displayed. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying all combinations of a range of numbers | Excel Worksheet Functions | |||
displaying specific rows on screen | Excel Discussion (Misc queries) | |||
hiding/displaying rows | Excel Discussion (Misc queries) | |||
Grand Totals for Rows not displaying | Excel Discussion (Misc queries) | |||
Displaying all rows, printing only certain rows | Excel Discussion (Misc queries) |