Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Syntax for "and" and "or"
Can someone please show me the proper syntax for using "and" and "or" operators with "if" in a Macro? Can they be used together? -- knowtrump ------------------------------------------------------------------------ knowtrump's Profile: http://www.excelforum.com/member.php...o&userid=19664 View this thread: http://www.excelforum.com/showthread...hreadid=503802 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Syntax for "and" and "or"
The best way is to use brackets to isolate the conditions.
If (A And B) Or _ (C And D) And _ (E Or D) Then 'do you stuff End If Note though that VB does not short circuit when testing, which can cause problems, which are invariably worse, more likey, harder to debug with such conditions. This means that even if a condition is met that would cause the overall test to fail, it still runs the other tests. If they could give rise to errors, you will get the error even if that test is irrelevenat in a particular case. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "knowtrump" wrote in message ... Can someone please show me the proper syntax for using "and" and "or" operators with "if" in a Macro? Can they be used together? -- knowtrump ------------------------------------------------------------------------ knowtrump's Profile: http://www.excelforum.com/member.php...o&userid=19664 View this thread: http://www.excelforum.com/showthread...hreadid=503802 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Syntax for "and" and "or"
Sub M()
Dim i, j, k As Integer i = 1 j = 2 k = 3 If (i = 1 And j = 2) Or k = 3 Then MsgBox ("true") End If End Sub ____________________________ Gary's Student "knowtrump" wrote: Can someone please show me the proper syntax for using "and" and "or" operators with "if" in a Macro? Can they be used together? -- knowtrump ------------------------------------------------------------------------ knowtrump's Profile: http://www.excelforum.com/member.php...o&userid=19664 View this thread: http://www.excelforum.com/showthread...hreadid=503802 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
correct syntax for nesting "if", "and", and "vlookup"....if possib | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |