VBA Tip: The IIF Statement

The IIf statement is a shorthand type of If..Then..Else statement. It evaluates a conditional expression then returns one value if the expression is true, and a different value if the expression is false. The syntax of the IIF statement is as follows:

IIF(<conditional expression>,<TRUE return value>,<FALSE return value>)

Here are examples for finding the maximum and minimum of two numbers. Since VBA has no built-in min or max functions these examples may find their way into many of your VBA applications.

dMax = IIf(dValue1 > dValue2, dValue1, dValue2)
dMin = IIf(dValue1 < dValue2, dValue1, dValue2)


The above IIF statements give the same result as the following If…Then…Else statements.

If (dValue1 > dValue2) Then
dMax = dValue1
dMax = dValue2
End If

If (dValue1 < dValue2) Then
dMin = dValue1
dMin = dValue2
End If

Rod Wing

Rod Wing

Rod joined EnvisionCAD in March 2007 and has nearly three decades of experience working in the CADD industry. He led the IT evaluations of Bentley InRoads and AutoDesk Civil 3D at Wisconsin DOT in their overall CAiCE replacement evaluation. He also led the MicroStation V7 to V8 upgrade effort at Wisconsin DOT which included updating not only the CADD standards to accommodate the changes in the file format but also updating legacy MDL and macros to work in the new environment. Rod received a Bachelor of Science degree from the University of Wisconsin in Cartography and a Master of Science in Geographic and Cartographic Sciences from George Mason University. Rod has extensive experience in CADD as well as the areas of GIS, cartography, plotting, scanning, raster editing/manipulation, publishing, and file/data translations. In all of these areas, he has produced custom tools and developed workflows to enhance productivity between diverse sets of applications. He instructs MicroStation classes ranging from fundamentals to advanced applications.


Leave a Reply

Your email address will not be published. Required fields are marked *