CreateEventProc Method (VBA Add-In Object Model)
This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.
Creates an event procedure.
Syntax
object**.CreateEventProc(eventname, objectname) As Long**
The CreateEventProc syntax has these parts:
Part |
Description |
---|---|
object |
Required. An object expression that evaluates to an object in the Applies To list. |
eventname |
Required. A string expression specifying the name of the event you want to add to the module. |
objectname |
Required. A string expression specifying the name of the object that is the source of the event. |
Remarks
Use the CreateEventProc method to create an event procedure. For example, to create an event procedure for the Click event of a Command Button control named Command1 you would use the following code, where CM represents an object of type CodeModule:
TextLocation = CM.CreateEventProc("Click", "Command1")
The CreateEventProc method returns the line at which the body of the event procedure starts. CreateEventProc fails if the arguments refer to a nonexistent event.