VBA code for IF statement with OR?
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. |
VBA code for IF statement with OR?
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. |
VBA code for IF statement with OR?
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. |
VBA code for IF statement with OR?
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 |
VBA code for IF statement with OR?
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 |
All times are GMT +1. The time now is 02:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com