Many of us here don't use macros, but if you post a pic of what your macro steps look like (or write everything out) we're willing to take a shot at it.
It sounds like yours is trying to do something (maybe save data) during the close event, which cannot happen. In vba, the Unload event fires before the Close event, so data is gone at that point where the Close event takes over. My guess would be that a macro is no different in that respect.
IMO, best approach is usually to provide a Save/Close and Cancel buttons in your case. The lost focus event would NOT be the place I'd do anything like that. All the user has to do is give the last control the focus, then go back to a previous one to correct spelling - and the even will fire.
Last edited by Micron; 11-14-2016 at 04:53 PM.
Reason: spellin
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.