Highlight text in a combo box?

[razzandy]

Can the text be highlighted in a combo box? You know like when you make a selection from the combo box list the text is highlighted blue. I want the text already selected when the combo box is loaded up. I need something like the below code:

Combobox1.Selected(Combobox1.Listcount)

Thanks in advance

Ryan A UK

 

[KenCriss]

Don't know if this would apply to a combobox, but this has worked for me in a textbox.

Private Sub UserForm_Activate()
TextBox1.Text = ActiveWorkbook.Path & "\" & ActiveWorkbook.Name
TextBox1.SelStart = 0
TextBox1.SelLength = Len(TextBox1.Text)
End Sub

 

[razzandy]

Thanks for that. That’s some useful code I didn’t know about!

Cheers


Ryan A UK