Hi Robin,
When I added Userform1.Show vbModeless as the first line of my codes,
the Userform pops up but my codes just won't execute in the background
unless I click the X in the corner to close it first.

How can I have the userform show while my codes execute in the
background?

I do like the progress bar. I notice that it counts to 100 but does
this progress bar actually measure length of my code and increments
according to what has actually been completed?

Thanks again,
Ricky

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!