Use the X button on a userform

[Greg B]

I know how to disable the X button on a userform but I was wondering if
there was a possibility that when it is used that it opens the userform
splash?

Thanks in advance

Greg

 

[papou]

Hi Greg
Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode <> 1 Then
Splash.Show
End If
End Sub

HTH
Cordially
Pascal

 

[Greg B]

Thanks for that exactly what I needed

Greg

Hi Greg
Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode <> 1 Then
Splash.Show
End If
End Sub

HTH
Cordially
Pascal

 

[papou]

Thanks for that exactly what I needed
My pleasure, I am glad for that ;-)

Cordially
Pascal