Strings are a sequence of characters, which can consist of alphabets or numbers or special characters or all of them. A variable is said to be a string if it is enclosed within double quotes " ".
Syntax :
variablename = "string"
Examples :
str1 = "string" ' Only Alphabets str2 = "132.45" ' Only Numbers str3 = "!@#$;*" ' Only Special Characters Str4 = "Asc23@#" ' Has all the above
String Functions :
There are predefined VBA String functions, which help the developers to work with the strings very effectively. Below are String methods that are supported in VBA. Please click on each one of the methods to know in detail.
| Function Name | Description |
|---|---|
| InStr | Returns the first occurence of the specified substring. Search happens from left to right. |
| InstrRev | Returns the first occurence of the specified substring. Search happens from Right to Left. |
| Lcase | Returns the lower case of the specified string. |
| Ucase | Returns the Upper case of the specified string. |
| Left | Returns a specific number of characters from the left side of the string. |
| Right | Returns a specific number of characters from the Right side of the string. |
| Mid | Returns a specific number of characters from a string based on the specified parameters. |
| Ltrim | Returns a string after removing the spaces on the left side of the specified string. |
| Rtrim | Returns a string after removing the spaces on the right side of the specified string. |
| Trim | Returns a string value after removing both leading and trailing blank spaces. |
| Len | Returns the lenght of the given string. |
| Replace | Returns a string after replacing a string with another string. |
| Space | Fills a string with the specified number of spaces. |
| StrComp | Returns an integer value after comparing the two specified strings. |
| String | Returns a String with a specified character the specified number of times. |
| StrReverse | Returns a String after reversing the sequece of the characters of the given string. |
