Modal window
 

Hmm sorry if this posts twice my first seems to have disappeared.

Long story short, I have a modal userform that is called from a vb
routine, gets information, click a button and returns to the main
application and the process continues.

The weird thing is that even though as part of the button clicked
subroutine I tell the userform to hide it will not go away. I have
tried putting the hide code into the main routine, I have tried the
unload command. Nothing I do will make this form go away, until the
entire process is completed.

Any tricks to making this window disappear prompty?

Modal window
 

make sure you don't have screenupdating set to false.

--
Regards,
Tom Ogilvy


"Merlin" wrote:

Hmm sorry if this posts twice my first seems to have disappeared.

Long story short, I have a modal userform that is called from a vb
routine, gets information, click a button and returns to the main
application and the process continues.

The weird thing is that even though as part of the button clicked
subroutine I tell the userform to hide it will not go away. I have
tried putting the hide code into the main routine, I have tried the
unload command. Nothing I do will make this form go away, until the
entire process is completed.

Any tricks to making this window disappear prompty?