In section 22.2 we designed a macro that calculates the value of using Monte Carlo and

In section 22.2 we designed a macro that calculates the value of π using Monte Carlo and 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.