Okay, when I "show" the userform, the initialization sub is running, and that
what's taking the time. Now I need to figure out why it's initializing,
instead of just activating.

"Die_Another_Day" wrote:

Put a break point on the command to re-activate the userform, then
single step through until you find the command that zaps all the time.

Charles Chickering

Stratuser wrote:
There are no frames on the userform. And when the form is activated, the
code just resets some of the checkboxes. The filesearch procedure that fills
the two listboxes happens during the initialization only. That's why I
can't figure out what's taking so long when all I'm doing is reactivating the
userform.

"Stratuser" wrote:

I have a userform that has two list boxes, each of which are filled with
about 100 filenames. Even when I have run this form before and already have
it loaded with data and the form is just hidden, it takes several (7-10)
seconds to reappear when I invoke it again. I'm trying to figure out a way
to speed up the reappearance of the form when I call it again. If I'm not
adding any data to the listboxes or re-running the filesearch command that I
used to fill the listboxes, why should it take this long for it to reappear
when called? Any ideas for speeding it up?