Use the X button on a userform
 

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

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" a écrit dans le message de news:
...
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

Thanks for that exactly what I needed

Greg
"papou" wrote in message
...
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" a écrit dans le message de news:
...
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

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

Cordially
Pascal

"Greg B" a écrit dans le message de news:
...
Thanks for that exactly what I needed

Greg
"papou" wrote in message
...
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" a écrit dans le message de news:
...
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