I tried something similar to this before, and it did not work. However,
this code does work. I'm not sure why my code didn't work, but thanks
so much, Tom! This form now works great.


Tom Ogilvy wrote:

Private Sub Userform_Activate()
ComboBox1.SetFocus
If ComboBox1.Text = "" Then
ComboBox1.SelStart = 0
Else
ComboBox1.SelStart = 0
ComboBox1.SelLength = Len(ComboBox1.Text)
End If
End Sub


is a possibility. Worked for me with hiding the form.