I would like to know how to do an If statement in VBA which is the similar
to using OR in excel functions. eg.


I would like to do something like

If Var1 = 23 or 34 then
Var = "Hello"
end if


any help is appreciated, thanks.

One way:

If Var1 = 23 Or Var1 = 34 Then Var = "Hello"

In article ,
"Dave R." wrote:

I would like to know how to do an If statement in VBA which is the similar
to using OR in excel functions. eg.


I would like to do something like

If Var1 = 23 or 34 then
Var = "Hello"
end if


any help is appreciated, thanks.

Perfect! Thanks!


"JE McGimpsey" wrote in message
...
One way:

If Var1 = 23 Or Var1 = 34 Then Var = "Hello"

In article ,
"Dave R." wrote:

I would like to know how to do an If statement in VBA which is the
similar
to using OR in excel functions. eg.


I would like to do something like

If Var1 = 23 or 34 then
Var = "Hello"
end if


any help is appreciated, thanks.

Good evening Dave R

This is how to do what you are asking. The code will throw up a
message box containing the value of Var, only if Var1=23 or 34, so
change the value of Var1 and re-run the code to see the routine in
action.

Sub Demo()
Var1 = 23 'Change this value and re-run the code
If Var1 = 23 Or Var1 = 34 Then
Var = "Hello"
MsgBox Var
End If
End Sub

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=382126

Thank you DominicB.


"dominicb" wrote in
message ...

Good evening Dave R

This is how to do what you are asking. The code will throw up a
message box containing the value of Var, only if Var1=23 or 34, so
change the value of Var1 and re-run the code to see the routine in
action.

Sub Demo()
Var1 = 23 'Change this value and re-run the code
If Var1 = 23 Or Var1 = 34 Then
Var = "Hello"
MsgBox Var
End If
End Sub

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile:
http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=382126