P.J.C. Hausoul
New Member
- Joined
- Dec 23, 2004
- Messages
- 28
Hello,
My setup is as follows ; i have a macro that uses a lot of different userforms that are organized into a menu structure . So one userform calls the other and when it is closed the previous one is shown again . Here the problem starts , when excell is visible under the userforms there remains a residual image of the userform that was last openend.
I'd like to remove that image so that only the active userform is shown.
Maybe i lack the proper understanding of the processes involved .
As i understand it , a userform can be shown and hidden , but also unloaded . which should remove it from the memory , and the screen.
So to quote a piece of code :
(this is the method i use to call a different userform)
Private Sub commandbutton1_click
Userformx.show
End Sub
(this is the code i use to go back to the previous userform)
Private Sub ExitButton_click
Unload Me
End Sub
So what am i doing wrong ? Please help me
My setup is as follows ; i have a macro that uses a lot of different userforms that are organized into a menu structure . So one userform calls the other and when it is closed the previous one is shown again . Here the problem starts , when excell is visible under the userforms there remains a residual image of the userform that was last openend.
I'd like to remove that image so that only the active userform is shown.
Maybe i lack the proper understanding of the processes involved .
As i understand it , a userform can be shown and hidden , but also unloaded . which should remove it from the memory , and the screen.
So to quote a piece of code :
(this is the method i use to call a different userform)
Private Sub commandbutton1_click
Userformx.show
End Sub
(this is the code i use to go back to the previous userform)
Private Sub ExitButton_click
Unload Me
End Sub
So what am i doing wrong ? Please help me