View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Corey Corey is offline
external usenet poster
 
Posts: 363
Default Select another Textbox After Selection

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