ComboBox Sort

[Guest]

Whenever I change an item in my combobox, it doesn't resort the items. If I
add an item, then it sorts ok. Is this normal?

 

[Herfried K. Wagner [MVP]]

Whenever I change an item in my combobox, it doesn't resort the items. If
I
add an item, then it sorts ok. Is this normal?

I am able to reproduce this behavior. Quick workaround:

\\\
With Me.ComboBox1
.Items(2) = "ZZZZ"
.Sorted = False
.Sorted = True
End With
///

 

[Guest]

Thanks. I thought I'd tried that but apparently I only reset the sorted
property True and didn't set it to False first.

 

[Herfried K. Wagner [MVP]]

I thought I'd tried that but apparently I only reset the sorted
property True and didn't set it to False first.

That's what I tried too ...