Author: K Z

Sub Procedures are similar to functions, however there are a few differences. Sub procedures DO NOT Return a value while functions may or may not return a value.Sub procedures CAN be…

A functions is a group of reusable code which can be called anywhere in your program. This eliminates the need of writing the same code over and over again. This enables the…

The Erase Function is used to reset the values of fixed size arrays and free the memory of the dynamic arrays. It behaves depending upon the type of the arrays.…

The IsArray Function returns a boolean value that indicates whether or NOT the specified input variable is an array variable. Syntax IsArray(variablename) Example Add a button and add the following…

A Filter Function, which returns a zero-based array that contains a subset of a string array based on a specific filter criteria. Syntax Filter(inputstrings,value[,include[,compare]]) Parameter Description Inputstrings − A required parameter.…

A Join Function, which returns a string that contains a specified number of substrings in an array. This is an exact opposite function of Split Method. Syntax Join(List[,delimiter]) Parameter Description…

A Split Function returns an array that contains a specific number of values split based on a delimiter. Syntax Split(expression[,delimiter[,count[,compare]]]) Parameter Description Expression − A required parameter. The string expression that…

The UBound Function returns the largest subscript of the specified array. Hence, this value corresponds to the size of the array. Syntax UBound(ArrayName[,dimension]) Parameter Description ArrayName − A required parameter. This…

The LBound Function returns the smallest subscript of the specified array. Hence, LBound of an array is ZERO. Syntax LBound(ArrayName[,dimension]) Parameter Description ArrayName − A required parameter. This parameter corresponds to…

We know very well that a variable is a container to store a value. Sometimes, developers are in a position to hold more than one value in a single variable…