Key press event, in he formula bar

can the formula editor bar can receive events?

No, it cannot.

You can use the worksheet_change event to capture the value or formula entered in a cell.

Hello krish,

This is an interesting question. Excel does not expose any Formula Bar events through VBA, but it does receive events. The Formula Bar is made up of 2 child windows. The Name Box, which is a ComboBox Class window, and the Formula Bar, which is an Edit Box Class window. The window class names are "ComboBox" and "Excel<", respectively.

Knowing this information can allow us to construct code to listen in on the messages these windows receive and act accordingly. This requires using using extensive API (Applications Programming Interface) calls. VBA supports the API interface which allows us to access and control low level system operations.

All in all, it is possible to construct code that would recognize keystrokes in the Formula Bar and know when the "Enter" key had been pressed. The text could then be retrieved, compared, and the appropriate macro called. The drawback here is API code is complex and not user friendly. As I have time, I will work on this. It is a good challenge.