Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
close form
Supose I want to close a form. I put an EXIT buttion on the form. I just
want to close the form, no checking just unload or close the form How do I do this in Excel 2007. What simple code goes in the button command sub? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
close form
Unload Me
Jacob (If this post helps please hit Yes) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
close form
thats what I thought, but it does not work. Niether does frmMain.close.
2007 is a different animal. "Jacob Skaria" wrote in message ... Unload Me Jacob (If this post helps please hit Yes) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
close form
It works in xl2007, your original post asking how to do was answered. You
have a different question as to why is does not work, so describe your environment. -- Regards, Nigel "Striker" wrote in message ... thats what I thought, but it does not work. Niether does frmMain.close. 2007 is a different animal. "Jacob Skaria" wrote in message ... Unload Me Jacob (If this post helps please hit Yes) |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
close form
There are some differences in Excel2007, but not that much in VBA. Unload Me
should work if the code is in the form's code module. If you post the code that is not working, it is easier for those offering assistance to see where the problem might be. "Striker" wrote: thats what I thought, but it does not work. Niether does frmMain.close. 2007 is a different animal. "Jacob Skaria" wrote in message ... Unload Me Jacob (If this post helps please hit Yes) |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
close form
OK, looks like I had a dot in there, that did not need to be there.
(Unload.Me) My memory must be failing me this is the way I rememberd it from years past. Obviously I didn't remember it correct. Thanks "Nigel" wrote in message ... It works in xl2007, your original post asking how to do was answered. You have a different question as to why is does not work, so describe your environment. -- Regards, Nigel "Striker" wrote in message ... thats what I thought, but it does not work. Niether does frmMain.close. 2007 is a different animal. "Jacob Skaria" wrote in message ... Unload Me Jacob (If this post helps please hit Yes) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Close Form | Excel Programming | |||
Form.Close | Excel Programming | |||
Close a form when you click outside of the form | Excel Programming | |||
Call user form from ThisWorkbook; close file if form closed | Excel Programming | |||
close .chm with form | Excel Programming |