download
order  

Visual Basic 6 and VBA code fragments for Conditions

 

In the Visual Basic 6 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

{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} 

Conditions neq