The reply was incomplete ....

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)

select case criteria
case "not in system"
' your code
case "NOT OKC"
' your code code
case else
' your code
end sub



"AA2e72E" wrote:

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