combobox list

[bam12]

I have a user form with a combobox with a list of about 20 items. When I run the macro it it always has an item hilighted in about the center of the list.

Is there code i can put in to keep the hilight bar always at the top of the list

thanks for any help

 

[erik.van.geit]

bam12,

When I run the macro it it always has an item hilighted in about the center of the list.

seems to me you've some code which is doing this
what's the code you're currently using ?
would this help ?

Private Sub UserForm_Initialize()
ComboBox1.Value = ComboBox1.List(0)
End Sub

kind regards,
Erik

 

[bam12]

code fro combobox

this is the code i have for the combobox

Private Sub combobox1_Click()
Range("h26") = ComboBox1
End Sub

 

[erik.van.geit]

that's the code used when you click it, whic doens't have any influence on the selection
do you have code like I posted ? (Initialize)
please try also the code provided

 

[bam12]

thanks

Thanks Erik

that work

appreciate the help

Have nice holiday season