Excel Vba - Text Box active by default
 

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

--
Message posted from http://www.ExcelForum.com

Excel Vba - Text Box active by default
 

Hi ALdo

In the userform module:

Private Sub UserForm_Initialize()
TextBox2.SetFocus
End Sub

HTH. Best wishes Harald

"ajliaks " skrev i melding
...
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.


---
Message posted from http://www.ExcelForum.com/

Excel Vba - Text Box active by default
 

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).

--
Regards,
Tom Ogilvy


"ajliaks " wrote in message
...
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.


---
Message posted from http://www.ExcelForum.com/