Move the code which updates the userform on open to a separatesub/function. Call the sub on activation and then call the sub afteryou do the calculation.