a macro will pause when a message box is initiated anyway and continue when it is closed so just
msgbox "Program Paused - Click OK to continue"
inside the loop would work