I have a listbox where I need to check against multiple conditions being true.
This works to light 1 row that matches a name variable called ydna(primary):
[code] dim nam as string
dim nam2 as string
if row < me.ListCount then
nam = me.cell(row,0)
nam2 = Mid(nam, Instr(nam, ": ") + 2)
If nam2 = ydna(primary) then
g.ForeColor = &c324F17
g.FillRect(0, 0, g.Width, g.Height)
end if
end if[/code]
How do i change this where multiple rows might be true? For example, I need to check here for names matching ydna(1), ydna(2), ydna(3) and ydna(4) and light those row(s) green.