Data table & VBA

Birdy92 · Apr 29th, 2002, 02:54 PM

I have a data table that automatically opens with excel. What I am trying to do is when the user is finished entering thier data into the table and clicks on the close button it will automatically run that macro that I have already developed that sorts the data into the person's individual sheet and compiles that data into a group sheet.

Mark O'Brien · Apr 29th, 2002, 02:59 PM

You want to use the "BeforeClose" event: stick this on the "ThisWorkbook" object:

Private Sub Workbook_BeforeClose(Cancel As Boolean)

   YourMacroName 'here

End Sub

Where "YourMacroName" is the name of your macro.

HTH

Birdy92 · May 2nd, 2002, 12:33 PM

Mark,
I have been trying a few different things with the code you gave me, it seems that it only works when I close the file out and not when I close the data form....What could I be missing here?

Apr 29th, 2002, 02:59 PM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	You want to use the "BeforeClose" event: stick this on the "ThisWorkbook" object: Private Sub Workbook_BeforeClose(Cancel As Boolean) YourMacroName 'here End Sub Where "YourMacroName" is the name of your macro. HTH __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 29th, 2002, 02:54 PM	#1
Birdy92 New Member Join Date: Apr 2002 Posts: 14	I have a data table that automatically opens with excel. What I am trying to do is when the user is finished entering thier data into the table and clicks on the close button it will automatically run that macro that I have already developed that sorts the data into the person's individual sheet and compiles that data into a group sheet.

May 2nd, 2002, 12:33 PM	#3
Birdy92 New Member Join Date: Apr 2002 Posts: 14	Mark, I have been trying a few different things with the code you gave me, it seems that it only works when I close the file out and not when I close the data form....What could I be missing here?