Auto close user form

[murty473]

Hi all,

Is it possible to automatically close the userform after I finished my job. I mean, after I clicked on a button it should be closed automatically.

Is there any way to do it?

Kind Regards

 

[craig.penny]

Try this

Private Sub MyButton_Click()
'Your existing code for the button
Me.Hide
End Sub

 

[murty473]

Try this

Private Sub MyButton_Click()
'Your existing code for the button
Me.Hide
End Sub

Thank you. It works fine.

Regards