Hi bforster1
Unload UserForm1
Read this KB
http://support.microsoft.com/default...b;EN-US;829070
--
Regards Ron de Bruin
http://www.rondebruin.nl
"bforster1" wrote in message ...
I am having trouble with a userform that opens sometimes and gives and
error other times.
How do I code displaying and then unloading a userform? I have tried
UserForm.Show vbModeless (this works) but when I close UserForm.Hide
and try to reopen (UserForm.Show vbModeless) I get a error.
Please help.
Thanks.
--
bforster1
------------------------------------------------------------------------
bforster1's Profile: http://www.excelforum.com/member.php...o&userid=11771
View this thread: http://www.excelforum.com/showthread...hreadid=275882