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

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/

Background calculation w/o updating cells
 

Sweet! Thanks alot

--
Message posted from http://www.ExcelForum.com