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