CreateEventProc method (VBA Add-In Object Model)

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

See also

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.