Remove residual image of userforms

[P.J.C. Hausoul]

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

 

[tusharm]

Just a guess...have you tried Hide and then Unload?

 

[Chris Davison]

I had this too.... I think I tried switching the application.screenupdating back on temporarily before unloading, then off again

application.screenupdating = true
unload UF_myuserform
application.screenupdating = false
rest of macro

(obviously, the downside is that the screenupdating slows your code down a touch)

cheers
Chris