Thread
:
closing user form
View Single Post
#
2
Posted to microsoft.public.excel.programming
Tushar Mehta
external usenet poster
Posts: 126
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
Reply With Quote
Tushar Mehta
View Public Profile
Find all posts by Tushar Mehta