Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Query not installed for New Database Query | Excel Discussion (Misc queries) | |||
Web Query Help... | Excel Discussion (Misc queries) | |||
"Query cannot be edited by the Query Wizard" | Excel Discussion (Misc queries) | |||
how to create button commande to refresh data in query in excel 2. | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |