The Application object has a Cursor property that you can use to change the appearance of the cursor in your VBA programs. You use it like
Application.Cursor = xlWait
The valid settings are
Be sure to set it back to xlDefault when you’re done monkeying with it.