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
>
>
>

Thanks did not think of it that way

Greg

*** Sent via Developersdex http://www.developersdex.com ***

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

Greg
"Greg B" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>