Thanks for the clear answers guys

I'm thinking then that perhaps I can trap the events for the userform,
then with the BeforeUpdate event check that a Textbox has the focus
before running my code...

Just out of interest, do you have the same WithEvents limitations if
coding directly in VB rather than VBA?

All the best
Lloyd