UserForm Question

[bforster1]

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

 

[Ron de Bruin]

Hi bforster1

Unload UserForm1

Read this KB
http://support.microsoft.com/default.aspx?scid=kb;EN-US;829070