Detect Edit Mode

[EssoExplJoe]

I have a macro that runs when a user clicks a button shape. If the user has entered data in a cell but has not hit return or selected another cell then clicks on the button to run the macro, the data in the cell used in the Macro is the old data instead of the new data entered. Is there any way to ensure that the cell is exited before the macro is run? My only solution so far is to check in the macro. I tried selecting a "home" cell in the macro when it starts with a "doevents" but still the old data in the cell is used. Anyone know how to resolve this and have the macro run the new data in the cell. According to what I can find on the internet, Excel has no way of detecting if a cell is under edit in VBA.

[Bernie Deitrick]

Excel will not allow a macro to run when in Edit mode. Clicking the button in this example workbook takes Excel out of edit mode and completes the entry in the cell being edited. My simple test macro uses the new value that was being entered at the time of the button being clicked.

If you could share a (much simplified) version of your workbook that displays the behavior you describe, then that would allow us to figure out what is going on.

[EssoExplJoe]

Thanks for feedback. The resetting a range to the active cell worked ok. Problem solved.