Eisasuarez
Well-known Member
- Joined
- Mar 23, 2012
- Messages
- 653
Hi All
How can i have a vba code to consense multiple or criterias
Say i wanted to check to see
If txtboxtest.value <> "Name1" or txtboxtest.value <> "Name2" etc... (There could be multiple Names to check for)
How can i condense this rather than writing multiple or statements?
P.s i could also have a range set up on say sheets Access Range A2 to last row therefore i coukd say if the txtboxtest.value <> (In that range list) then do what ever but im stuck how to condense this?
Would i need a loop?
How can i have a vba code to consense multiple or criterias
Say i wanted to check to see
If txtboxtest.value <> "Name1" or txtboxtest.value <> "Name2" etc... (There could be multiple Names to check for)
How can i condense this rather than writing multiple or statements?
P.s i could also have a range set up on say sheets Access Range A2 to last row therefore i coukd say if the txtboxtest.value <> (In that range list) then do what ever but im stuck how to condense this?
Would i need a loop?