VBA – Erase Function
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.…
VBA
VBA – IsArray Function
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…
VBA – Filter Function
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.…
VBA – Join Function
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…
VBA – Split Function
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…
VBA – UBound Function
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…
VBA – LBound Function
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…
VBA – Arrays
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…
VBA – Time Value Function
The TimeValue Function converts the given input string to a valid time. Syntax TimeValue(StringTime) Example Add a button and add the following function. Private Sub Constant_demo_Click() msgbox(TimeValue("20:30")) msgbox(TimeValue("5:15")) msgbox(TimeValue("2:30:58")) End…
VBA – Time Serial Function
The TimeSerial function returns the time for the specified hour, minute, and second values. Syntax TimeSerial(hour,minute,second) Parameter Description Hour − A required parameter, which is an integer between 0 and 23…