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

On Mar 19, 1:50*pm, Libby <Li...@discussions.microsoft.com> wrote:
> 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

Why not set it so that

If Len(TextBox1.Value)>0 Then
TextBox2.Visible = True
End If

That way if the textbox 1 is empty it wont allow the end-user to jump
to the next textbox?