Hi there,

I have a workbook with one worksheet and a userform.
The userform is loaded by clicking a button on the worksheet and it has on
it textboxes for information to be entered.

The information that goes in these textboxes is often source from other open
applications and the user toggles between the workbook and this application
via alt+tab.

The problem is that supposing textbox1 on the userform has focus and the
user goes to another application to get information, when they return to the
from textbox1 has lost focus and and has to be clicked again.

Is there anyway to retain the focus of a control on a userform when
returning to it from another application?

Many thanks in advance