Combo Box Lose Focus

[AlexanderBB]

What's the correct way for a UserForm) combo box to Lose the focus?

I anticipate calling this from the cbo_Change event.
I did try to setFocus to a text box (left = -50) but you still see a flashing cursor , so made the left -999 and locked = True.
That did it but seems a hack and there must be a better way?
Thanks.

 

[Yongle]

To change the focus to TextBox1 when ComboBox1 changes

Private Sub ComboBox1_Change()
  TextBox1.SetFocus
End Sub

 

[AlexanderBB]

I know, but what if you don't want to Set it anywhere - just lose it from the Combo Box ?

 

[Yongle]

Add a commandbutton with Height 1 and Width 1
- set the focus to that
- the user will not even realise it is there

Private Sub ComboBox1_Change()
    CommandButton5.SetFocus
End Sub