View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default UserForm locking up

When you unload a userform, that should be it. Any code that you try to run
after that unload should be in the procedure that showed the form initially,
not in the userform itself.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"excelnut1954" wrote in message
oups.com...
Thanks for the responses guys. I may just use Bob's suggestion for the
quick fix for now. But I'll look at Tom's reply later, break it down,
and maybe use that idea. More things to take into consideration, I
guess. I didn't realize there would be a problem unloading a userform
at any point.
Thanks again for the quick responses.
J.O.