Hi,

I am trying to hide a VBA excel form and wrote a piece of code in userform_deactivate(). But the control is not passing through the deactivate. Can any one tell me why?? There is another way by using "unload me" and userform_terminate() but, i dont want to use this.

So, what i want to know, How to execute a piece of code when form hides.

Thanks

Johnson

The only way is to use UserForm_Terminate that works for me any way.

The code you write in Userform_deactivate is not executed before you deactivate the userform. You dont use it to deactivate the form.

If you want to hide the userform without terminating it, use Me.Hide or the userforms name instead of Me.

Likewise use 'userformname'.Show to view it again (from another form or worksheet, which of cause means you cant use Me.).

Didn't notice the last part of your Q.

Hiding the userform doesn't mean you can't execute some other code. E.g. if you hide the userform by clicking a button you could code this in the button click event:

Me.Hide
Me.BackColor = vbRed

Check it out - put at button in your worksheet and add this code:

'userformname'.show

Thanks for your reply Birger... that's what i did finally.