Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum of values based on different criteria | Excel Discussion (Misc queries) | |||
Looking up values with multiple criteria | Excel Worksheet Functions | |||
Looking up values based on two criteria | Excel Worksheet Functions | |||
Frequency of values with Criteria | Excel Worksheet Functions |