| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Having "Or" in If statements in VB doesn't work?
I was trying this statement:
If a = 2 or b =2 then ..... But the b = 2 doesn't get tested for some reason, why is that? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Having "Or" in If statements in VB doesn't work?
You might want to tell us what a & b are. -- Don Guillett SalesAid Software "J@Y" wrote in message ... I was trying this statement: If a = 2 or b =2 then ..... But the b = 2 doesn't get tested for some reason, why is that? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Having "Or" in If statements in VB doesn't work?
I would separate the line as follows:
If a = 2 then blah blah blah elseif b = 2 then blah blah blah End If Or, if you want to test for both equalling 2: If a = 2 then If b = 2 then etc. -- Pops Jackson "J@Y" wrote: I was trying this statement: If a = 2 or b =2 then ..... But the b = 2 doesn't get tested for some reason, why is that? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Having "Or" in If statements in VB doesn't work?
On Jun 15, 11:27 am, J@Y wrote:
I was trying this statement: If a = 2 or b =2 then ..... But the b = 2 doesn't get tested for some reason, why is that? If a = 2, the Or expression will evaluate to True regardless of the value of b. If you require both variables to be equal to 2 to get a result of True you need to use And rather than Or: If a = 2 and b = 2 then [...] |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Having "Or" in If statements in VB doesn't work?
It isn't, at least for me:
Dim a As Long Dim b As Long a = 0 b = 0 If a = 2 Or b = 2 Then MsgBox "a: " & a & " b: " & b a = 2 b = 0 If a = 2 Or b = 2 Then MsgBox "a: " & a & " b: " & b a = 0 b = 2 If a = 2 Or b = 2 Then MsgBox "a: " & a & " b: " & b In article , J@Y wrote: I was trying this statement: If a = 2 or b =2 then ..... But the b = 2 doesn't get tested for some reason, why is that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =SUBSTITUTE(C4,"~?#","") will this work to remove multiple string | 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) | |||
| Read ".dll" files, the Macro "work flow" and the actual values of the variables when Macro is running | Excel Programming | |||
| pictures to work with "data" "sort" option | Excel Discussion (Misc queries) | |||
| I'm desperate I posted earlier about "If" statements that don't work but are correct. Now... | Excel Worksheet Functions | |||
Linear Mode
