Monthly Archives: September 2020

Last Updated on January 11, 2023 by token 1. StrReverse VBA Function – Description The StrReverse VBA function   returns text with characters in reverse order. If we want to reverse characters in a text string starting from the last one, we should use this function. 2. VBA Replace function – […]

Last Updated on January 11, 2023 by token 1. StrConv VBA Function – Description The StrConv VBA function  converts a text value by specified in the second argument of the parameter. With this function, you can, among other things, convert a string to uppercase like the VBA UCase function . […]

Last Updated on January 11, 2023 by token 1. StrComp VBA Function – Description The StrComp VBA function   compares the length of strings in two texts. Depending on the difference in length, the function returns the values ​​1, 0 or -1. 2. VBA StrComp Function – Syntax StrComp (String1, String2, […]

Last Updated on January 11, 2023 by token 1. Str VBA function – Description The VBA Str function   converts a numeric value to the String data type  . The simplest form of the String data type with a variable number of characters takes up as many bytes in memory as […]

Last Updated on January 11, 2023 by token 1. Space VBA function – Description The Space VBA function returns the number of spaces specified in the argument. So, if we want to get a text with only 100 spaces, enter the number 100 in the argument. 2. VBA Space function […]

Last Updated on January 11, 2023 by token 1. RTrim VBA function – Description The RTrim VBA function removes spaces from the right side of text. We use it when we want to remove unnecessary spaces from the right side of a text string. If, however, we want to remove […]

Last Updated on January 11, 2023 by token 1. RIGHT VBA function – Description The RIGHT function in VBA cuts the specified number of characters from the text starting from the right side. It can be compared to the RIGHT function in an Excel worksheet. The function cuts text from […]

Last Updated on January 11, 2023 by token 1. Replace VBA function – Description The  Replace VBA  function is used to replace strings. If we want to replace a word or a fragment of text with another, we use the Replace function. The function has additional arguments with which we […]

Last Updated on January 11, 2023 by token 1. MID VBA function – Description The MID VBA function is equivalent to the SUBSTRING or SUBSTR function in other programming languages. How does the MID function work? The VBA MID function cuts text from other text. For example, from the sentence […]

Last Updated on January 11, 2023 by token 1. LTrim VBA function – Description LTrim VBA function removes spaces from left side of text. We use it when we want to remove unnecessary spaces from the left side of a text string. If we want to remove spaces from the […]

Last Updated on January 11, 2023 by token 1. Len VBA function – Description The VBA Len function returns the string length for the given argument. How to use it? All you have to do is enter some text as an argument to the function. The function can be compared […]

Last Updated on January 11, 2023 by token 1. LEFT VBA function – Description The LEFT function in VBA cuts a specified number of characters from the text starting from the left side. It can be compared to the LEFT function in an Excel worksheet. The function cuts text from […]

Last Updated on January 11, 2023 by token 1. LCase  VBA function  – Description The LCase VBA function converts all letters in a string to lowercase. This can be compared to the LOWER function in an Excel worksheet. How to use LCASE function in VBA Excel? In the argument of […]

Last Updated on January 11, 2023 by token 1. InStrRev VBA function – Description The InStrRev VBA function   returns the character position in the string starting from the end. If we want, which position in a given text is occupied by a character or word, we should use this function. […]

Last Updated on January 11, 2023 by token 1. InStr VBA function – Description The InStr VBA function returns the position of a character in a string. If we want which position in a given text a character or word occupies, we should use this function. This function can also be […]

Last Updated on January 11, 2023 by token 1. Chr VBA function – Description The Chr VBA function   returns a character based on the position in an ASCII character array. For example, the letter “a” in the ASCII code table is position 97. If we would like to get the […]