Hi, I have never done any macros in vba for excel. I have however don
some vb, but it was a long time ago. If i remember well Private Su
Form_Unload(Cancel As Integer) was everything u wanted to do before
closed ur form. Heres the beginning of the code i was working on.
Nothing happens on the form unload, i tryed putting a messagebox there
but nothing happened. Is there something u gotta do differently in vb
then in vb

Thanks
Ben

Option Explicit

Private Sub Form_Load()

End Sub

Private Sub Form_Unload(Cancel As Integer)

If ThisWorkbook.Saved = False Then
ThisWorkbook.Save
End If

ThisWorkbook.Close

End Su

--
Benny578
-----------------------------------------------------------------------
Benny5788's Profile: http://www.excelforum.com/member.php...fo&userid=2497
View this thread: http://www.excelforum.com/showthread.php?threadid=38502