Question: In section we designed a macro which calculates the value of π using Monte Carlo and which updates the screen every iteration. Modify the macro so that it updates the screen only every 1,000 iterations.
Hints:• Use the VBA function Mod . From the VBA help menu, note that this function has syntax a Mod b. (A similar Excel function has syntax Mod(a,b) , but cannot be used in VBA.)
• Use the VBA commands Application.ScreenUpdating = True and Application. ScreenUpdating = False to control the updating of the screen.