Public Variables with UserForms
"Mark Worthington" wrote in message
...
Bob,
That still leaves the (very small)
issue of the extra overhead of updating the progress indicator . but one
can't get away from that.
It has to happen somewhere, it's our lot to have to do it.
One other point : there is no UserForm equivalent of EnableEvents =
False .... so I use a module level Boolean check.
That's how I do it. If set on entry, exit, else set it and reset on exit.
Again, a major hassle, but it works well.
|