Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
X button query
Thanks did not think of it that way Greg *** Sent via Developersdex http://www.developersdex.com *** |
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why does edit query button not open query | Excel Discussion (Misc queries) | |||
X button query | Excel Discussion (Misc queries) | |||
how to create button commande to refresh data in query in excel 2. | Excel Discussion (Misc queries) | |||
Command button macro query | Excel Programming | |||
Assigning a query to a control button | Excel Programming |