>Yes use programmatically, and no RowSource for the listbox.
>
>I only use AddItem to add values to the List Box and I want to search our the value in the List Box.
>But don't want using the Looping scan the whole List Box.
>
>Derek
If you need to find an index of the value, then the only way is a loop, though you may try to use some searching algorithms here.
I would simply loop
for lnI = 1 to this.Count
...
next
I don't think you would have too many items with AddItem, so looping will not degrade performance.
If it's not broken, fix it until it is.
My Blog