![]() |
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
| Tags: close, userform1 |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
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 |
| Ads |
|
#2
|
|||
|
|||
|
A user form has neither of those methods, as you can see in the Object
Browser. Use Unload UserForm1. -- 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 "ExcelLars" wrote in message ... 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 |
|
#3
|
|||
|
|||
|
Thanks! it works!
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Cant start new e-mail when Userform1 are open | ExcelLars | Outlook - Using Forms | 1 | May 14th 08 11:15 AM |
| Close a Excel Workbook when close a userform in Outlook | lars.oyangen@hamstad.no | Outlook and VBA | 2 | May 8th 08 03:54 PM |
| Why is the "X" used for delete so close to the "save and close"? | Carol | Outlook - Using Contacts | 3 | July 29th 07 04:31 AM |
| Close Message, Close Outlook | cdf | Outlook - General Queries | 2 | April 16th 07 04:42 PM |
| OE doesn't close | Andre De Clercq | Outlook Express | 2 | April 13th 07 03:45 AM |