Why is my UserForm Pausing Procedure?

Some quick background:

Excel 97
UserForm is a progress bar (from j-walk), named frmProgress

I have a procedure written to import a text file and complete various formatting to the data. The procedure takes a while in two different areas, so I have created a progress bar UserForm to indicate the progress (obviously) of each of these two tasks.

My problem is that when the UserForm is shown, the procedure is paused. It will just sit there and not do anything. However, if I close the UserForm, the procedure will continue. If I type CTRL + Break, the frmProgress.Show line is highlighted. This also occurs when the UserForm is shown the second time in my procedure.

Does anyone know what is causing this? Here is an excerpt of my first loop with the UserForm:

Please Login or Register  to view this content.

TIA

Jason

Hello Jason,

By default, UserForms are created as modal dialogs. This means that when the user form is displayed, that it alone receives user input. Control is returned to the calling thread after the form has been closed. This is why iyour code is pausing when the user form is shown.

Sincerely,
Leith Ross

Thanks, Leith. I guess I can separate my procedure into a few different procedures, and then call the next procedure after the UserForm is shown from the Activate event handler.

Jason