Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
To create an event handler for an event of the Application object, you need to complete the following three steps: 1.Declare an object variable in a class module to respond to the events. 2.Write the specific event procedures. 3.Initialize the declared object from another module. Declare the Object Variable Before you can write procedures for the events of the Application object, you must create a new class module and declare an object of type Application with events. For example, assume that a new class module is created and called EventClassModule. The new class module contains the following code. Public WithEvents App As Application Write the Event Procedures After the new object is declared with events, it appears in the Object list in the class module, and you can write event procedures for the new object. (When you select the new object in the Object list, the valid events for that object are listed in the Procedure list.) Select an event from the Procedure list; an empty procedure is added to the class module. Private Sub App_NewPresentation() End Sub Initializing the Declared Object Before the procedure will run, you must connect the declared object in the class module (App in this example) with the Application object. You can do this with the following code from any module. Dim X As New EventClassModule Sub InitializeApp() Set X.App = Application End Sub Run the InitializeApp procedure. After the procedure is run, the App object in the class module points to the Microsoft Office PowerPoint Application object, and the event procedures in the class module will run when the events occur.
|Excel Formatting test||26||65|
|Word 2016 - Spelling/Grammar Check - Inconsistent behavior upon completion||7||86|
|how to open abcd.txt.orig file?||10||45|
|help with an excel problem||10||29|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
6 Experts available now in Live!