Duplicate Values in a list box

[unstoppable]

Hey fellow programmers,

Is there any quick way of checking for a duplicate item inside the listbox before you add it. For example:

Before I add "Text" to the listbox, I want to make sure "Text" is not there already.

Thanx

 

[Katerine]

Hi unstoppable,
What VBA program is this?

The reason I ask is that if it's Access, and the rowsource of the listbox is a table or a query, the answer is totally different than if it's set through the List property to an array programmed in, say, Word, or if the rowsource is a range in Excel.