Excel Vba - Text Box active by default

A

ajliaks

Hi all,

I am using a user for which contains two text boxes.

I want TextBox2 being my default option when userform activates.

I need to show the cursor into TextBox2 and ready to input data.
Could anyone help, please?

Thanks in advance,
Aldo
 
H

Harald Staff

Hi ALdo

In the userform module:

Private Sub UserForm_Initialize()
TextBox2.SetFocus
End Sub

HTH. Best wishes Harald
 
T

Tom Ogilvy

If by activate, you mean when the userform is first shown (created), then
set the tabindex property to 0

If hiding and showing again, then see Harald's post (which should work in
the above as well, but setting the tabindex should also be done).
 
Top