Your query is not very clear.

Criteria:="not in system" suggests that you are calling a routine which
expects an argument called Criteria.

If I understand the rest of the query, you want to control the flow of the
code depending on the value of Criteria. Try


Sub xx(ByVal Criteria as string)




"DKY" wrote:


I have something that looks like so in a macro code.
Criteria1:="not in system"
how do I make it for more than one thing? I want the criteria to be
"not in system" or "NOT OKC". I dont even know how to word this to get
my answer with microsoft help. Any guidance would be appreciated.
Thanks in advance.


--
DKY
------------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=275631