We still use Excel 97 at my place of work (don't ask).

I'd like to display a "Please wait while processing..." message (a UserForm
with an animated GIF) while the VBA is running and processing. Is this
possible to do? Whenever I do Form.show, the VBA code stops until I close
the UserForm. I really don't want to move all the code into the Form if
possible.