Thread: HOW to close a userform using a button
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
  
Posts: 9,101
Default 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 ?
Reply With QuoteReply With Quote