The following simple code sets up .OnEntry on the active sheet to run macro DCCapture. When I edit a cell and hit the enter key, it works and selects cell 4,4. When I edit a cell and use the formula check instead of the enter key, I get run-time error ‘50290’ Application-defined or object-defined error. The macro does nothing but select a cell. Here’s the code,

Sub SetOnEntry()
ActiveSheet.OnEntry = “DCCapture”
End Sub
‘
Public Sub DCCapture()
Cells(4, 4).Select
End Sub

I would like the macro to work with both the Enter key or clicking on the formula bar check. I thought they were treated the same in the background, but it seems not. Any help would be really appreciated.

Thank you in advance,
Eloy

I’d like the macro to recognize and accept the formula bar check the same as the enter key.