| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm
Hi all,
Can some please tell me the command to close a user form after a command button has been pressed. Many thanks Andy |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
UserForm
Depends whether you want to unload the form or merely hide it. If you want to
bring it back looking the same as the user left it then just hide the form. Additionally if you want to get data from the form into the rest of your application often it is best to just hide it. The two possibles are userform1.hide and unload userform1 You could also use me.hide or unload me -- HTH... Jim Thomlinson "Andy the yeti" wrote: Hi all, Can some please tell me the command to close a user form after a command button has been pressed. Many thanks Andy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Userform to enter values and shown in same userform in list | Excel Programming | |||
| Looping procedure calls userform; how to exit loop (via userform button)? | Excel Programming | |||
| Activating userform and filling it with data form row where userform is activate | Excel Programming | |||
| Access from add_in userform to main template userform.... | Excel Programming | |||
| Linking userform to userform in Excel 2003 | Excel Programming | |||
Linear Mode
