Application.OnEntry
 

I have Ver. 6.3 of VBA for Excel. The book I am learning from must be for an
earlier version, because it includes a property or method for the application
object called onentry. But my version of VBA doesn't recognize it. Has it
been replaced? Or is there a library I can install to get it? I can't find
another way to run a routine when something is entered into a cell. Thanks!

Application.OnEntry
 

You should use the Workbook_Change event. See your help file!

"CathyJ" wrote:

I have Ver. 6.3 of VBA for Excel. The book I am learning from must be for an
earlier version, because it includes a property or method for the application
object called onentry. But my version of VBA doesn't recognize it. Has it
been replaced? Or is there a library I can install to get it? I can't find
another way to run a routine when something is entered into a cell. Thanks!