closing user form
 

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

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

closing user form
 

Thanks,
I tried, but it didn't help.
Henry


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