Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unloading userforms
Hi
I have wrote a few macros to open up a userform and when finished, with a comand boutton open a different userform. I keep getting an error 28 after running them for a little while. I have recreated the problem by writing the following code to establish the loading of userforms is the problem. has anyone got any suggestions on how i can resolve the problem. Thanks in advance Addy Private Sub CommandButton1_Click() Unload userform2 Set userform2 = Nothing Run "a" End Sub Sub a() userform1.Show Unload userform1 Set userform1 = Nothing End Sub Private Sub CommandButton1_Click() Unload userform1 Set userform1 = Nothing Run "b" End Sub Sub b() userform2.Show Unload userform2 Set userform2 = Nothing End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unloading DLL's | Excel Programming | |||
Unloading a Form | Excel Programming | |||
Unloading a form using the ESC key | Excel Programming | |||
Unloading A Form | Excel Programming | |||
Unloading an Add-In | Excel Programming |