I am having trouble with a userform that opens sometimes and gives an
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.Hid
and try to reopen (UserForm.Show vbModeless) I get a error.

Please help.

Thanks

--
bforster
-----------------------------------------------------------------------
bforster1's Profile: http://www.excelforum.com/member.php...fo&userid=1177
View this thread: http://www.excelforum.com/showthread.php?threadid=27588

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