I load list box with file data of 5 elements(k2,k2,k3,k4,k5) with up to 10000 results
I get the sum of these elements to be some integer(3,6,7,8,9,11)
I write a code to eliminate some results like this
If (k1+k2+k3+k4+k5) <> 3 or
(k1+k2+k3+k4+k5) <> 6 or
If (k1+k2+k3+k4+k5) <> 7 or
(k1+k2+k3+k4+k5) <> 8 or
If (k1+k2+k3+k4+k5) <> 9 or
(k1+k2+k3+k4+k5) <> 11 then
listbox.add(k1 " ;" & _
k2 " ;" & _ etc
Is it possible to write a code that reflects all these integer(3,6,7,8,9,11) at ones?
Software/Hardware used:
ASKED:
March 27, 2010 12:40 AM
UPDATED:
March 29, 2010 2:33 PM
To be more emphatic, the condition in the original question will always evaluate to true, and thus it is useless.