Hello Nigel,

Have you tried to use the lostfocus event? I'm not sure whether it works 
or not, but then you should be able to use the Form1.ActiveControl 
property.

Hope it helps,

Sincerely, Yoel Pedersen