How do I place cursor into TextBox or CombBox?

[HvyEquipment]

Hopefully, this is an easy question:

I have a sequence of textboxes and comboboxes on a userform and I would like to make one of the textboxes active (ie cursor blinking in that textbox ready to accept user input) based upon the combobox selection.

For example:

Combobox1 items = Text1, Text2 & Text3

Select Text2 from the Combobox1 and the cursor needs to move to Text2 and wait on the user to input text.

For whatever reason, I cannot figure out how to do this, can anyway please steer me in the right direction?

 

[hatman]

something like this, i would think

Private Sub ComboBox1_Change()

    Dim item As MSForms.Control

    For Each item In Me.Controls
    
        If item.Name = Me.ComboBox1.Value Then
        
            item.SetFocus
            
        End If
    
    Next item
    

End Sub