A Progress bar is a good way of letting you know that your code is still working, especially if you have disabled screen updating.

This workbook contains a collection of different progress meters.

Bar
Circle
Fancy bar
Blips
Status bar
Spinning hoop
Animated bar
Rotary dial

All of the meters are constructed from the standard toolbox controls.
The images were all created use the Autoshapes in Excel.

PowerPoint presentation progress add-in by Olaf Nöhring for PC and Mac