View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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.