View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tushar Mehta Tushar Mehta is offline
external usenet poster
 
Posts: 126
Default closing user form

Without seeing the code, this is just a guess.

Add a DoEvents after the Hide.

Alternatively, and depending on what you are doing, consider
{userform}.Repaint

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article ,
says...

I have a sort routine that starts with a user form to get input and then
opens a series of input boxes. I have the hide command for the user form
but the form does not go away untill all the input boxes have been
filled. i would like the user form to close right away.


--
hwolf60
------------------------------------------------------------------------
hwolf60's Profile:
http://www.excelforum.com/member.php...o&userid=17492
View this thread: http://www.excelforum.com/showthread...hreadid=480093