Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to close a form in vba (not hide)
Hi all,
i have an initialisation problem. i am using a form to add data to an excel sheet. When the user has finish his work he click on a button and i use: userform1.hide in the on click event to close the form because i cannot do what i really want wich is to close the form. How can i close or unload the form? after that, if the user call back the macro, the initialize function of the form is not called (because it is simply hide) and this screw my initialisation. I want a clean way to close or quit or unload the form. help regards, pierre |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to close a form in vba (not hide)
Hi Pierre
Use Unload Me See also http://support.microsoft.com/default...b;EN-US;829070 -- Regards Ron de Bruin http://www.rondebruin.nl "Pierre" wrote in message ... Hi all, i have an initialisation problem. i am using a form to add data to an excel sheet. When the user has finish his work he click on a button and i use: userform1.hide in the on click event to close the form because i cannot do what i really want wich is to close the form. How can i close or unload the form? after that, if the user call back the macro, the initialize function of the form is not called (because it is simply hide) and this screw my initialisation. I want a clean way to close or quit or unload the form. help regards, pierre |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to close a form in vba (not hide)
thanks again Ron
Ron de Bruin a écrit dans le message ... Hi Pierre Use Unload Me See also http://support.microsoft.com/default...b;EN-US;829070 -- Regards Ron de Bruin http://www.rondebruin.nl "Pierre" wrote in message ... Hi all, i have an initialisation problem. i am using a form to add data to an excel sheet. When the user has finish his work he click on a button and i use: userform1.hide in the on click event to close the form because i cannot do what i really want wich is to close the form. How can i close or unload the form? after that, if the user call back the macro, the initialize function of the form is not called (because it is simply hide) and this screw my initialisation. I want a clean way to close or quit or unload the form. help regards, pierre |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to close a form in vba (not hide)
Hi,
unload userform1 will be fine. Pierre a écrit : Hi all, i have an initialisation problem. i am using a form to add data to an excel sheet. When the user has finish his work he click on a button and i use: userform1.hide in the on click event to close the form because i cannot do what i really want wich is to close the form. How can i close or unload the form? after that, if the user call back the macro, the initialize function of the form is not called (because it is simply hide) and this screw my initialisation. I want a clean way to close or quit or unload the form. help regards, pierre |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Close Button Excel 2007 | Excel Discussion (Misc queries) | |||
Hide worksheets before close | New Users to Excel | |||
close (hide) toolbars | Excel Discussion (Misc queries) | |||
Hide, not close, one workbook | Excel Programming | |||
Hide minimise, maximise, and close buttons on form | Excel Programming |