View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen[_2_] Per Jessen[_2_] is offline
external usenet poster
 
Posts: 703
Default Make sure all items in a Collection equal the same thing


Hi Ryan

First I would compare against a constant value, earlier elements in my
collection as it requires that first item is equal to "Complete"

Second, my code would look like this:

For Each colItem In colSalesOrderStatus
If colItem < "Complete" Then
'Do something
Exit For
End If
Next

Regards,
Per

On 24 Sep., 00:20, RyanH wrote:
Is there another way to test if all item value in a Collection or Array are
the same thing? *For example, I want to make sure that all items in the
Collection or Array = "Complete". *here is the code I use. *I was wondering
if I am doing this a long about way.

*For j = 1 To colSalesOrderStatus.Count - 1
* * *If colSalesOrderStatus(j) < colSalesOrderStatus(j + 1) Then
* * * * * 'do something
* * * * * Exit For
* * * End If
*Next j
--
Cheers,
Ryan