| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unloading UserForm not working
Can anyone think of why this generic code doesn't seem to alway unload a userform?
UserFormn.Hide Unload UserFormn UserFormm.Show where n and m are numbers for the Userforms..... Seems odd to me? Could it be a memory thing? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Unloading UserForm not working
I suspect you are unloading it in an event for that form. The form can't
unload if the event is still operating - perhaps because you are showing another modal form. When the code finishes executing/the event is completed, then it will unload. -- Regards, Tom Ogilvy "Marston" wrote in message om... Can anyone think of why this generic code doesn't seem to alway unload a userform? UserFormn.Hide Unload UserFormn UserFormm.Show where n and m are numbers for the Userforms..... Seems odd to me? Could it be a memory thing? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Unloading UserForm not working
Marston,
You mean that "n" & "m" are variables and you trying to use this routine to allow manipulation of multiple UserForms, named UserForm1, UserForm2, UserForm3,... etc ? NickHK "Marston" wrote in message om... Can anyone think of why this generic code doesn't seem to alway unload a userform? UserFormn.Hide Unload UserFormn UserFormm.Show where n and m are numbers for the Userforms..... Seems odd to me? Could it be a memory thing? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Userform in excel97 not working right! | Excel Programming | |||
| Unloading userform in MSComm event | Excel Programming | |||
| Userform not working | Excel Programming | |||
| Not Unloading a UserForm | Excel Programming | |||
| EnableancelKey=xlErrorHandler not working in UserForm | Excel Programming | |||
Hybrid Mode
