200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
I failed recently to program an if statement if vba.
dim IfStatement as string
IfStatement= "(activecell.value=200900)"
IfStatement=IfStatement & "or (activecell.value=7206)"
if IfStatement then
' Do this and do that
end if
It could be that I just failed in the building of the IfStatement. My question is: Can one build an if statement for use in vba?
Thanks muchly
Michael
Yes you can for sure use IF statements in VBA; this is one of the cornerstones of making more complex macros. It looks like you are a little confused about how they work.
Here is the basic syntax:
If condition Then
'Do something
End Ifcondition must evaluate to True or False
Here is our tutorial on IF statements in VBA and that should help you better understand how to use them.
I'm not sure what you are trying to do with this variable: IfStatement
In your example, you use only text in the condition and you can't evaluate straight-up text in the way that you are trying to do it.
You should put any values that you want to compare into separate variables and then compare them within the IF statement's condition or just reference the values directly within the condition.
So, maybe you are trying to do something like this:
If ActiveCell.Value = 200900 Or ActiveCell.Value = 7206 Then
MsgBox "Hi"
End If