Getting excel to refresh the screen

Figured this out today:

just toggle Application.ScreenUpdating with:

Application.ScreenUpdating = False
Application.ScreenUpdating = True

and excel will refresh the screen.

so make a routine and call it refresh:

sub refresh
Application.ScreenUpdating = False
Application.ScreenUpdating = True
end sub



sub test1
Call initturtle: For j = 1 To 6: For i = 1 To 20: lt 360 / 20: fd 20: call refresh : Next i: rt 60: Next j
end sub