Close user form when button is pressed
 

Hi! i have a button in a user form. when this button is pressed i want the
user form to close. however, i do not seem to manage this. in the code for
the button antother program is called. but the problem seems to be that the
buttons code is declared private and when i write Close userForm1 the
computer says it is incompatible types. help!!

Close user form when button is pressed
 

Hi April27,

Look at the Unload statement in VBA help.

The following worked for me:

'=============
Private Sub CommandButton1_Click()
Unload Me
End Sub
'<<=============


---
Regards,
Norman


"april27" wrote in message
...
Hi! i have a button in a user form. when this button is pressed i want the
user form to close. however, i do not seem to manage this. in the code for
the button antother program is called. but the problem seems to be that
the
buttons code is declared private and when i write Close userForm1 the
computer says it is incompatible types. help!!