Thread: Form Unload
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Khai[_2_] Khai[_2_] is offline
external usenet poster
 
Posts: 7
Default Form Unload

When I use VBA in Excel, and one form opens another which has a close
button on it, I'd figure that the close button would run "Unload Me" and it
would get rid of the 2nd form.

However, it closes the whole macro, including the original form.

I've tried Hide/Show, but if I click on the "X", it still closes my form and
my entire macro. Any suggestions on how I can just get the 'X' and Close
button to just hide/close that second form instead of exiting the whole
macro?

-khai