Delaying calculations
 

daver676 wrote:

Hello All!

Is there a way I can allow users of my program to enter
all the criteria they need for their reports BEFORE Excel
starts calculating it. AS in, wait until all info is
entered before starting to calculate? Right now, they
enter a date, and 10 part numbers into a form. After any
one of these fields is entered, excel pauses to calculate
the SDUM cells behind it before it lets the user move on.
I would like them to be able to enter all the data FIRST,
and then allow Excel to calculate it. Thanks

Dave
You could turn off automatic calculations. Then using the worksheet
change event, on the last field, issue a command to calculate.

Application.CalculateFull