Excel VBA CommandBar buttons are not responsive when cell is in Edit Mode
Posted on 2014-08-12
In Excel, we are using VBA to create a CommandBar with several buttons.
Things are working fine, except in one case:
While the user is editing a cell, and he clicks on a CommandBar button, the click event is not triggered in VBA. In essence, the button does nothing and gives no feedback when the cell is in Edit Mode.
How does one get around this issue? The user might be confused as to why nothing is happening after entering a cell value and immediately clicking on a CommandBar button.