VBA Setfocus to next textbox

Hi All,

I have been looking around but unable to get this to work correctly. I have a userform with a combobox and a textbox. Currently it is set to setfocus on the combobox when the userform is opened. What I would like to do....After the combobox selection has been made (from a dropdown), setfocus is automatically shifted to the textbox. It seems simple enough, but every example I have tried so far, hasn't worked out. Help is appreciated.

Thank you,
Patrick

What if they don't use the dropdown in the ComboBox?
you can use an on change trigger but it would go off when character is typed in.

Hi Leon,

I am encouraging the users of the form to utilize the dropdowns to prevent other issues down the line. This is just the 1st stop in a longer process. Other sheets will be opened and or populated partly based on the names listed in the dropdown. So with that in mind, I am trying to keep this as fail free as possible.

For the 1st part I am using this code:

Private Sub Workbook_open()
UserForm1.CMB_Lead.SetFocus

UserForm1.Show
 End Sub

So, after the user picks from the list, I would like the focus to shift to a text box called TB_Logon. I need nothing other than to get the flashing cursor to move from CMB_Lead to TB_logon. I would prefer that it happen without the user having to tab or enter if possible.

Private Sub ComboBox1_Change()
Me.TB_Logon.SetFocus
End Sub

will move to the text box when the value in combobox 1 (replace with your box name) changes. however if users try to type manualy it will move to the text box after the first character is typed in.