Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Background calculation w/o updating cells
I've got a small problem.
I have a userform with an interface connecting textboxes to cells in worksheet. On the worksheet there is a quite complex equation with lot of cross references. Now I want to simulate what happens if one of th input variables vary from one value to another. The problem is, I wan this to happen in the background, so that the graphs on the workshee won't "flash" and change for every value in the loop. I'm thiking o something like this (pseudo code): For value = 3 to 7 Set one of the input cells to value Get result(value) from result cell Next Can this calculation be "simulated" so that it doesn't show on th worksheet? Thanks in advance -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Background calculation w/o updating cells
Turn off Screen Updating while it calculates the loop, then turn it back on
to display the results. Application.ScreenUpdating = False For value = 3 to 7 Set one of the input cells to value Get result(value) from result cell Next Application.ScreenUpdating = True Mike F "phreud " wrote in message ... I've got a small problem. I have a userform with an interface connecting textboxes to cells in a worksheet. On the worksheet there is a quite complex equation with lots of cross references. Now I want to simulate what happens if one of the input variables vary from one value to another. The problem is, I want this to happen in the background, so that the graphs on the worksheet won't "flash" and change for every value in the loop. I'm thiking of something like this (pseudo code): For value = 3 to 7 Set one of the input cells to value Get result(value) from result cell Next Can this calculation be "simulated" so that it doesn't show on the worksheet? Thanks in advance! --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Background calculation w/o updating cells
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating charts when Manual Calculation enabled | Excel Discussion (Misc queries) | |||
Why is my calculation not updating in a table? | Excel Discussion (Misc queries) | |||
how can you put a background in certain cells | Excel Worksheet Functions | |||
Constant Cell calculation updating | Excel Discussion (Misc queries) | |||
URGENT - Calculation not updating | Excel Discussion (Misc queries) |