terminate a form
 

what is the coding to close a form:
user form named frmCenter. on click event of button i want to terminate
frmCenter.

Thanks in advance.


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=478322

terminate a form
 

frmCenter.Hide
************
Anne Troy
www.OfficeArticles.com

"tkaplan" wrote in
message ...

what is the coding to close a form:
user form named frmCenter. on click event of button i want to terminate
frmCenter.

Thanks in advance.


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile:
http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=478322

terminate a form
 

FYI - i tried:
frmCenter.close
frmCenter.exit
frmCenter.terminate

none of these worked. frmCenter.hide is not an option because there is
code in the on terminate event.


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=478322

terminate a form
 

.hide just hides it- it is not equivilant to hitting the x in the
corner. I have code that is running off of the on terminate event so
this wont do it.


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=478322

terminate a form
 

Unload me

?????



tkaplan wrote:

what is the coding to close a form:
user form named frmCenter. on click event of button i want to terminate
frmCenter.

Thanks in advance.

--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=478322

--

Dave Peterson

terminate a form
 

Thank you!

That did it:)


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=478322