Textbox

R

ranswrt

How do I get a curser to move to a textbox in a userform when a button is
clicked?
Thanks
 
J

JLGWhiz

I created a UserForm with three text boxes. Then I used the initialize event
to put the cursor in TextBox3, I used double click events in TextBox 3 and 2
to move the cursor to TextBoxes 2 and 1 respectively. Then a double click
event in TextBox1 to close the UserForm. Here is the code behind the
UserForm:

Private Sub TextBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
Unload Me
End Sub

Private Sub TextBox2_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
TextBox1.SetFocus
End Sub

Private Sub TextBox3_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
TextBox2.SetFocus
End Sub

Private Sub UserForm_Initialize()
Me.TextBox3.SetFocus
End Sub

Of course, the UserForm1.Show command is issued from the standard code module.
 

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

How to tab to next from a texbox 2
Access Dateadd function question.. 0
Userform textbox string to header causes unwanted double spacing 4
Userform Textbox to Worksheet Textbox 1
Firing Event in another user form 1
Copy value of textbox to clipboard for use in another application 5
userform textbox returns changeable date 4
Excel UserForm textboxes and checkboxes??? 3

Top