Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Closing Excel user form generates error | Excel Discussion (Misc queries) | |||
Closing a Form | Excel Discussion (Misc queries) | |||
Closing user form in Initialize macro? | Excel Programming | |||
How to: User Form to assign a user defined range to a macro variab | Excel Programming | |||
HELP! - Closing form | Excel Programming |