VBA Events
Syntax
-
Source Module:
[Public] Event [identifier]([argument_list]) -
Handler Module:
Dim|Private|Public WithEvents [identifier] As [type]
Remarks
-
An event can only be
Public. The modifier is optional because class module members (including events) are implicitlyPublicby default. -
A
WithEventsvariable can bePrivateorPublic, but notFriend. The modifier is mandatory becauseWithEventsisn't a keyword that declares a variable, but a modifier keyword part of the variable declaration syntax. Hence theDimkeyword must be used if an access modifier isn't present.
