"Run macro on exit" not firing

A

A. Ahola

Hello,

I have a dropdown formfield in a protected form, thats supposed to fire a
macro when the user exits the formfield. The problem is, that if the user
exits the formfield via clicking somewhere in the form thats not an another
formfield, the macro wont fire. If the user tabs out or clicks a formfield,
the macro works fine.

Is this a feature? Workarounds anybody?

Thanks,
Amos
 
T

Tony Jollans

It's a 'feature'. On and off I have been trying to write an AddIn to deal
with this but it's easier said than done and I haven't managed to get
anything to fully work.

If you want to code it yourself for a specific situation you can use the
Application WindowSelectionChange event to catch the user action and drive
the macros from that.
 
Top