Create a busy indicator

Create a busy indicator

Hello,
I use a VBA procedure to analyse and write huge files.
It takes a while to write all the data to the files.
To show the user, that the application is busy but didn't crash, I would like to display a hourglas (or something else).
I think it should be something like this:
display hourglas
... do all the file I/O...
hide hourglas
Normally in VBA there is a DoCmd.Hourglas method. But DoCmd class is not available in my modules.
Thanks in advance.
Alex

This is a migrated post! Originally posted on 17.10.2012 by user gralex. Please be aware that information can be outdated.