Check collection for specific value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ramon - 27 Jul 2006 17:32 GMT

Hello,

I need to check if a collection contains a specific value. Is there a way to
do this without looping?

Thanks!
Ramon.

Reply to this Message

Karl E. Peterson - 27 Jul 2006 18:55 GMT

> I need to check if a collection contains a specific value. Is there a
> way to do this without looping?

Ask for it, and error-trap.
--

Reply to this Message

Michael B. Johnson - 28 Jul 2006 15:43 GMT

>I need to check if a collection contains a specific value. Is there a way to
>do this without looping?

If it is a *value*, /not/ a key, then no - I know of no way to accomplish this
without looping through the values in the collection.

I hope this makes sense: If you built an array that indexed the values in the
collection and they were sorted in order of increasing value, then perhaps you
could use a binary search type probe.
_______________________
Michael B. Johnson

Reply to this Message

VB Forum / General 2 / July 2006

Check collection for specific value