textbox

[khatri milan]

I have created some textbox in my worksheet and when i finish giving input to one textbox and press enter i want the cursor to move into another textbox .How can i do this?Please help.

 

[KlaasE]

Try this. Replace TextBox1 and TextBox2 with the names of your Textboxes.

Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
        If KeyCode = 13 Then
             TextBox2.Activate
        End If
End Sub

 

[khatri milan]

to activate this sub , i will again need a command button ,so it is not easy than using mouse to move into another text box,no?

 

[khatri milan]

does this code works even if the text box is not in user form but in simple worksheet?

 

[KlaasE]

Have you tried it out? When you are finished with the input of the first textbox and you press enter, it will move to the second textbox.

 

[KlaasE]

Ah I see the misunderstanding. I assumed it was ActiveX textbox, which the code works for. I am actually not sure if you can do it with a formcontrol textbox. I'll have to check that.

 

[khatri milan]

Thank you verymuch, initially i was writing these code on a module and it didnot work but when i wrote same code in the coding window of sheet containing those textboxes, it worked fine. I appreciate your help verymuch.