Select another Textbox After Selection

[Corey]

Is there a way i can add a line of code when a textbox value has been entered, to go directly to
(and select) another textbox ?

I am actually using the MouseMove command, but want to eliminate the chance of the user NOT moving
the Mouse over the required Texbox to run the macro.

I want to do some thing like:

Private Sub ComboBox5_Change()
' What ever code here, then

' <==== MouseMove on Combobox6 ' To run procedure on Combobox6 (as below)

end sub



AND, then with Combobox6:

Private Sub ComboBox6_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single,
ByVal Y As Single)
ComboBox6.DropDown

'<==== MouseMove to be run on Textbox36 after Combobox6 value Changes
End Sub

Is there a way of doing this ?
How?

Corey....

 

[Corey]

I think there would be another way if you can code the mouse pointer to reposition elsewhere on the
userform.
Can this be done ?


Is there a way i can add a line of code when a textbox value has been entered, to go directly to
(and select) another textbox ?

I am actually using the MouseMove command, but want to eliminate the chance of the user NOT moving
the Mouse over the required Texbox to run the macro.

I want to do some thing like:

Private Sub ComboBox5_Change()
' What ever code here, then

' <==== MouseMove on Combobox6 ' To run procedure on Combobox6 (as below)

end sub



AND, then with Combobox6:

Private Sub ComboBox6_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single,
ByVal Y As Single)
ComboBox6.DropDown

'<==== MouseMove to be run on Textbox36 after Combobox6 value Changes
End Sub

Is there a way of doing this ?
How?

Corey....