HOW to close a userform using a button
 

To close a userform I wrote

Private Sub XX_Click()
UserForm.Close
End Sub

but don't Close the form I get the a error message " invallide qualifier "

HOW to close a userform using a button ?

HOW to close a userform using a button
 

You need to use the name of the userform like

UserForm1.Close


"CC" wrote:

To close a userform I wrote

Private Sub XX_Click()
UserForm.Close
End Sub

but don't Close the form I get the a error message " invallide qualifier "

HOW to close a userform using a button ?

HOW to close a userform using a button
 

This is a control (like a button) on that userform that you want to close:

Private Sub XX_Click()
unload me
End Sub

Me is the userform that owns the code.



CC wrote:

To close a userform I wrote

Private Sub XX_Click()
UserForm.Close
End Sub

but don't Close the form I get the a error message " invallide qualifier "

HOW to close a userform using a button ?

--

Dave Peterson