X button query
 

Hi all how can I have it when someone clicks on the X button of any userform
it loads up the userform"main"

Thanks in advance

Greg

Hi Greg,

Try inserting this code into the QueryClose event for each form in question:
Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode = vbFormControlMenu Then
main.Show
End If
End Sub

Hope this helps,

Mark


"Greg B" wrote:

Hi all how can I have it when someone clicks on the X button of any userform
it loads up the userform"main"

Thanks in advance

Greg

It is ok Some one has helped me on this one.

Greg
"Greg B" wrote in message
...
Hi all how can I have it when someone clicks on the X button of any
userform
it loads up the userform"main"

Thanks in advance

Greg