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

X button query
 

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

X button query
 

Thanks did not think of it that way

Greg

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

X button query
 

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