status bar for looping macro

[patrickgh]

I have a macro that changes the file location of my linked Excel spreadsheet. The process takes quite a while to complete and there is no indication that it is running until I pop up a msgbox at the end to let the user know it completed.

What I want to do is show a progress bar in a dialogue box, but can't find the code to write one for PowerPoint. Is there anything like what I'm looking for? I'll even settle for a passive window that tells the user to be patient while the operation runs and then pop up the msgbox