Thread: Userform close button
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
jhyatt jhyatt is offline
external usenet poster
  
Posts: 61
Default Userform close button
try this

Private Sub Userform_QueryClose(Cancel As Integer, closeMode As Integer)
If closeMode = 0 Then
Cancel = True
MsgBox "Please use the button!"
End If
End Sub

Reply With QuoteReply With Quote