OnData/ON.DATA Function Doesn't Work with Object Links (126316)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
This article was previously published under Q126316 SYMPTOMS
When you use the OnData property in a Microsoft Visual Basic for
Applications procedure in Microsoft Excel, the procedure that is set to run
does not run when dynamic data exchange (DDE) or OLE data arrives in
Microsoft Excel.
CAUSE
The OnData property only works when the updated object is a text string or
a formula, not a linked object that uses another format. Only linked text
values cause the procedure that is assigned (using the OnData property) to
run. This behavior also occurs with the Microsoft Excel 4.0 ON.DATA macro
function.
REFERENCES
For more information about the OnData Property, click the Search button in
the Visual Basic Reference and type:
| Modification Type: | Minor | Last Reviewed: | 8/15/2005 |
|---|
| Keywords: | kbinterop kbprb kbProgramming KB126316 |
|---|
|