Conditions

The VBA code fragments below are included in the Code-VB fragments library. Fragments are snippets of code you can insert in your procedures. Each item between braces correspond to a variable of the given type. They are replaced with the new or existing variables by Fragment Builder in Code-VB tools.

• eq
• geq
• gt
• Is Empty
• Is Even
• Is Missing
• Is Nothing
• Is Null
• Is Odd
• leq
• like
• lt
• neq

eq

{VARIANT:var1} = {VARIANT:var2}

geq

{VARIANT:var1} >= {VARIANT:var2}

gt

{VARIANT:var1} > {VARIANT:var2}

Is Empty

IsEmpty({VARIANT:var1})

Is Even

IIf((lngNumber Mod 2) = 0, True, False)

Is Missing

IsMissing({VARIANT:var1})

Is Nothing

{OBJECT} Is Nothing

Is Null

IsNull({VARIANT:var1})

Is Odd

IIf((lngNumber Mod 2) = 0, False, True)

leq

{VARIANT:var1} <= {VARIANT:var2}

like

{STRING:sText} Like {STRING:Pattern}

lt

{VARIANT:var1} < {VARIANT:var2}

neq

{VARIANT:var1} <> {VARIANT:var2}