Author: K Z

The Mid Function returns a specified number of characters from a given input string. Syntax Mid(String,start[,Length]) Parameter Description String − A required parameter. Input String from which the specified number of…

The Right function returns a specified number of characters from the right side of the given input string. Syntax Right(String, Length) Parameter Description String − A required parameter. Input String from…

The Left function returns a specified number of characters from the left side of the given input string. Syntax Left(String, Length) Parameter Description String − A required parameter. Input String from…

The UCase function returns the string after converting the entered string into UPPER case letters. Syntax UCase(String) Example Add a button and place the following function inside the same. Private…

The LCase function returns the string after converting the entered string into lower case letters. Syntax Lcase(String) Example Add a button and place the following function inside the same. Private…

The InStrRev function returns the first occurrence of one string within another string. The Search happens from the right to the left. Syntax InStrRev(string1,string2[,start,[compare]]) Parameter Description String1 − A required parameter.…

The InStr Function returns the first occurrence of one string within another string. The search happens from the left to the right. Syntax InStr([start,]string1,string2[,compare]) Parameter Description Start − An optional parameter.…

Strings are a sequence of characters, which can consist of either alphabets, numbers, special characters, or all of them. A variable is said to be a string if it is…

An Exit Do Statement is used when we want to exit the Do Loops based on certain criteria. It can be used within both Do…While and Do...Until Loops. When Exit Do is executed, the control jumps to the next statement…

An Exit Fors statement is used when we want to exit the For Loop based on certain criteria. When Exit For is executed, the control jumps to the next statement immediately after the For Loop. Syntax Following is…