using Criteria with two possible values
 

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 b
"not in system" or "NOT OKC". I dont even know how to word this to ge
my answer with microsoft help. Any guidance would be appreciated.
Thanks in advance

--
DK
-----------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...fo&userid=1451
View this thread: http://www.excelforum.com/showthread.php?threadid=27563

using Criteria with two possible values
 

Hi DKY

it would probably be better if you posted a bit more of your code, is this
for filtering of excel lists?
if so then

Selection.AutoFilter Field:=1, Criteria1:="=not in system",
Operator:=xlOr, _
Criteria2:="=NOT OKC"

if it's for something else, please post back

Regards
JulieD



"DKY" wrote in message
...

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

using Criteria with two possible values
 

DKY,

Criteria1:="=not in system", _
Operator:=xlOr, _
Criteria2:="=NOT OKC"

You could get that code by recording a macro and applying the autofilter.

HTH,
Bernie
MS Excel MVP

"DKY" wrote in message
...

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

using Criteria with two possible values
 

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

using Criteria with two possible values
 

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