Background calculation w/o updating cells

[phreud]

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

 

[Mike Fogleman]

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]

Sweet! Thanks alot