Simplify your code with Inc and Dec functions

Simplify your code with Inc and Dec functions

Unlike other languages – such as C and Delphi – VB lacks of the capability to increment and decrement a variable. Adding this feature, in the form of reusable Function routines, is simple:

Function Inc(Value As Variant, Optional Increment As Variant = 1) As Variant    Value = Value + Increment    Inc = ValueEnd FunctionFunction Dec(Value As Variant, Optional Decrement As Variant = 1) As Variant    Value = Value - Decrement    Dec = ValueEnd Function

The above routines declare the argument as Variant, so you can use them with any numeric data type, as in:

Dim x As Long, y As Single' increment a Long value by oneInc x' increment a floating point variable by 0.1Inc y, 0.1

You may argue whether using the Inc/Dec routines is going to make your code more or less readable. However, these functions prove to be more useful when they appear inside expressions:

' evaluate the sum of the squares of the first 100 integer numbers' (of course, you can do this also with a For-Next loop,'  but this is only an example)Dim N As Long, Sum As LongDo While N <= 100    ' increment N, square it, and add to the Sum variable    Inc Sum, Inc(N) ^ 2Loop

A final note: the Inc/Dec routines are slow, at least compared with inline addition and subtraction operations. For this reason you should never use them inside time-critical loops.

See also  Does It Make Sense to Splurge on a Laptop?

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist