Cycle through collection

[Ruegen]

Can you step through a collection object and compare the key values to a variable?

[ranman256]

pretty simple

sub CycleThruColl (pcol as collection)
dim itm

for each itm in pcol
   if itm = "myValue" then  DoMyEvent
next

[Ruegen]

pretty simple

sub CycleThruColl (pcol as collection)
dim itm

for each itm in pcol
   if itm = "myValue" then  DoMyEvent
next

Thanks - that is exactly what I required to get the job done. Thanks