Excel Workbook.BeforeClose Event

Posted on January 26, 2015 by Wyman W

Excel Workbook_BeforeClose Event Excel predefines some popular actions that you would do on different Objects (worksheet, workbook, button, etc), those actions are called Event. For example, activating a worksheet is an Event, closing a workbook is an Event, clicking on a button is an event. Each Object has its own list of Events, Workbook has a list of Events (e.g. close workbook, open workbook), worksheet has a list of Events (e.g. activate worksheet, edit a Cell). If you perform an Event...

Excel Workbook.Deactivate Event

Posted on January 25, 2015January 26, 2015 by Wyman W

Excel Workbook_Deactivate Event Excel predefines some popular actions that you would do on different Objects (worksheet, workbook, button, etc), those actions are called Event. For example, activating a worksheet is an Event, closing a workbook is an Event, clicking on a button is an event. Each Object has its own list of Events, Workbook has a list of Events (e.g. close workbook, open workbook), worksheet has a list of Events (e.g. activate worksheet, edit a Cell). If you perform an Event,...

Excel Workbook.Activate Event

Posted on January 25, 2015January 25, 2015 by Wyman W

Excel Workbook_Activate Event Excel predefines some popular actions that you would do on different Objects (worksheet, workbook, button, etc), those actions are called Event. For example, activating a worksheet is an Event, closing a workbook is an Event, clicking on a button is an event. Each Object has its own list of Events, Workbook has a list of Events (e.g. close workbook, open workbook), worksheet has a list of Events (e.g. activate worksheet, edit a Cell). If you perform an Event, s...

VBA Excel Workbook.Open Event

Posted on January 23, 2015January 28, 2015 by Wyman W

VBA Excel Workbook_Open Event Excel predefines some popular actions that you would do on different Objects (worksheet, workbook, button, etc), those actions are called Event. For example, activating a worksheet is an Event, closing a workbook is an Event, clicking on a button is an event. Each Object has its own list of Events, Workbook has a list of Events (e.g. close workbook, open workbook), worksheet has a list of Events (e.g. activate worksheet, edit a Cell). If you perform an Event,...

VBA Excel Worksheet.Change Event

Posted on January 1, 2015July 19, 2016 by Wyman W

This Excel VBA tutorial explains how to use Worksheet.Change Event. You may also want to read: Excel VBA get value before Worksheet_Change event Excel automatically refresh pivot table VBA Excel Worksheet_Change Event Excel predefines some popular actions that you would do on different Objects (worksheet, workbook, button, etc), those actions are called Event. For example, activating a worksheet is an Event, closing a workbook is an Event, clicking on a button is an event. Each Objec...

Excel VBA get value before Worksheet_Change event

Posted on January 1, 2015April 10, 2016 by Wyman W

This Excel VBA tutorial explains how to get value before Worksheet_Change event. Problem with getting value before Worksheet_Change event When we use Worksheet_Change event, the event is triggered after we edit a Cell (even no value is changed). For example, when A1 value is 10, we double click range A1 to change value to 20. As we press enter, Worksheet_Change event is triggered. As you can see, the old value 10 is not stored anywhere, but sometimes we do need the old value to do calculation....