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
- Collections (Visual Basic Add-In Model)
- Visual Basic Add-in Model reference
- Visual Basic language reference
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.