If Statement With Multiple Lines

vba if-statement line-breaks
Yokhen picture Yokhen · Nov 29, 2011 · Viewed 88.7k times · Source

I have an if statement with multiple conditions. I cannot see them all in a single window view. Is there a way to separate them on different lines or do they have to be written all in one line?

Answer

Cylindric picture Cylindric · Nov 29, 2011

The VBA line-continuation character is an underscore _

if ( _
    (something) _
    or (somethingelse) _
)

Related questions

VBA: Conditional - Is Nothing

There is an If condition in a VBA application as seen below: If Not My_Object Is Nothing Then My_Object.Compute When the code is run in debug mode, I found that the If condition returns a true even …

Read More
Excel VBA - Skip sub or end sub IF Statement

My code loops through cell values in a table and sees if document with same name exists. If it does exist, it will perform an action to open those files and import data. If bProcess Then FileCounter = 0 For Each folderIDX …

Read More
VBA: Break Out of Deeply Nested If Statements

Typically when I want to break out of a statement I just set a boolean flag for control flow, but I have a special case with many nested If statements and I'd really like to have a way to break …

Read More