Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select another Textbox After Selection
I think there would be another way if you can code the mouse pointer to reposition elsewhere on the
userform. Can this be done ? "Corey" wrote in message ... 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.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A Simply ComboBox Selection returns value to TextBox | Excel Programming | |||
Select Text in TextBox | Excel Programming | |||
Select text in textbox | Excel Programming | |||
Userform: Textbox changing with selection in combobox (list) | Excel Programming | |||
textbox selection to relative row? | Excel Programming |