Has anyone been able to get a progress bar type userform to work? I can get a form to open, but once the show is done, I can't get control back to the RE VBA Module - it stays on the userform. Thanks. [Email Removed] Andy Kessel -Clinton Foundation

I'm a little unsure what you mean here, but if you mean you display a form which carries out some task while showing the progress of the task with a progress bar on the form, then I would think that unloading the form at the end of the task with Unload Me would return you to the calling code. Or have I totally misunderstood the situation?

What I meant was that if I open the form from my vba macro the form takes over and won't let the "calling" subroutine continue, until I close the form - the whole point is to update the form from the main subroutine. Anyway.... I figured out the work around for this. Put the macro code in the form. Let it run in an onclick event and then the progress bar can be updated from within the form code. it can update itself.

Ah. Then I think your original problem was that the progress bar form was modal. Display it non-modally and your calling code will just continue on. It's set via the ShowModal property. Just for future reference.