CreateEventProc Method (VBA Add-In Object Model)

Microsoft VBA

CreateEventProc Method

           

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 a 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.