Close userform1?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ExcelLars - 15 May 2008 15:05 GMT

I have a commandobutton that i what to close a userform.
This code will not work:
Private Sub CommandButton9_Click()
userform1.close
userform1.unload
End Sub

Reply to this Message

Ken Slovak - [MVP - Outlook] - 16 May 2008 14:20 GMT

A user form has neither of those methods, as you can see in the Object
Browser. Use Unload UserForm1.

Signature

Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm

>I have a commandobutton that i what to close a userform.
> This code will not work:
> Private Sub CommandButton9_Click()
> userform1.close
> userform1.unload
> End Sub

Reply to this Message

Lars.Oyangen@gmail.com - 17 May 2008 00:38 GMT

Thanks! it works!

Reply to this Message