Excel Vba - Text Box active by default

  • Thread starter Thread starter ajliaks
  • Start date Start date
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
 
Hi ALdo

In the userform module:

Private Sub UserForm_Initialize()
TextBox2.SetFocus
End Sub

HTH. Best wishes Harald
 
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).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Arbitrary data to Textboxes in UserForm 4
Force proper case on user form text box 7
shorten a macro 2
Textbox Validation and Associated Checkbox 6
UserForm as Reader 3
Need help developing a Excel VBA Macro to Vaildate data entered intoa textbox 5
Input box question 6
how to input data into textboxes and make it appear on excel cells 6

Back
Top