To create an event procedure that is run when the Updated event occurs, set the OnUpdated property to [Event Procedure], and click the Build button.
To see if an object’s data has been changed since it was last saved, set a global variable in the Updated event procedure indicating that the object needs to be saved. When you save the OLE object, reset the variable.
Private Sub controlname_Updated (Code As Integer)
The Updated event procedure uses the following argument.
|
Argument |
Description |
|
controlname |
A string that is the name of the control affected by the Updated event procedure. |
|
Code |
An intrinsic constant that indicates how the OLE object was updated. The Code argument can have the following constants: |
|
Argument acOLEChanged |
Description Indicates that the object’s data has changed. |
|
acOLESaved |
Indicates that the object’s data has been saved by the application that created the object. This usually occurs when the user chooses the application’s Update command or whatever command is used for updating. |
|
acOLEClosed |
Indicates that the file containing the object’s data has been closed by the application that created the object. |
|
acOLERenamed |
Indicates that the file containing the object’s data has been renamed by the application that created the object. |
Updated Event — Macros.