But now replace the msgbox by a Stop statement. If you add a msgbox statement in the Workbook_Open handler, code execution will pause until the user closes the messagebox. Or in Workbook_Open you determine the language to be used in the custom control labels. For example, perhaps some controls must be hidden or disabled on startup. This gives you the opportunity to initialize any data structures that are used by the controls in the custom tab before these controls are loaded.
The trace list above makes clear that the custom tab is loaded after the three workbook events. Since most Excel applications have a single window interface we usually don’t need this event. Note that the Workbook_WindowActivate is always fired, even when your application has only one window. Consider this trace list as an extension of the VBE Call Stack.Īfter opening the workbook the trace list is:Īt startup Excel not only fires a Workbook_Open but also a Workbook_Activate and a Workbook_WindowActivate event. Most events have only two lines of code, to create a trace list in the VBE Immediate Window. In the workbook and worksheet modules all relevant events are defined. Opening the workbookĮxcelEvents1.xlsm is a workbook with two worksheets and two windows, and a custom tab with two cloned controls.
However, on Range level only an “Activate” event is fired (SelectionChange). Note that on every level two events are raised when switching to another object. You may keep this in mind when reading on.
The conceptual model in the figure above presents an overview of the five levels and their Activate/Deactivate events.
0 kommentar(er)
