searching 2nd column in multi-column listbox?

[RedGoneWILD]

Can anybody provide a basic way to search through a multi column listbox?

Basically, I'm adding two columns of data to a listbox at the click of a button. The 2nd column is names. Before being added to the listbox, I want to check that the name has not already been added already. If it has been added already, I am exiting the sub and trying again. What's the best way to compare a string value to the 2nd column of a list box? I've been trying for about a week and I'll I've been able to do is crash my program.



Thanks!

[pbaldy]

Well, you could certainly loop the items in the listbox, but I'd probably test the underlying table with a DCount().

[RedGoneWILD]

Is this the correct way to do it?

For i = 1 To Me.lstTest.ListCount - 1
If empName = Me.lstTest.Column(1, i) Then

PS: i starts at "1" because I have column headers and they don't need to be searched

[RedGoneWILD]

Also, there is no underlying table. it's unbound listbox. basically, i'm running a random function, and i want to make sure that the same employee isn't being randomly selected twice when the button is clicked.

[pbaldy]

Looks about right; does it work?

[RedGoneWILD]

no, it made my program unresponsive lol.

[pbaldy]

What's the rest of the code? You might have an endless loop.