Excel VBA Functions

1. CVar VBA function – Description The CVar VBA function   returns a value with the Variant data type  . The Variant data type can store both numeric and text data. When using this function, remember that the Variant data type itself is the least efficient data type in VBA. 2. […]

1. CStr VBA function – Description The CStr VBA function   returns a value of 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 there are characters in a given text string. We […]

1. CSng VBA Function – Description The CSng VBA function   returns a value with the Single data type  . It is a number between -3.402823e38 and 1.401298e45  . The Single data type is 4 bytes in memory. We usually use functions when we want our data to be more efficient. […]

1. CLngLng VBA function – Description The CLngLng VBA function   returns a value of the LongLong data type  . It is an integer ranging from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 . The LongLong data type is 8 bytes in memory. It is important that the LongLong data type itself, unlike the Long […]

1. CLng VBA function – Description The CLng VBA function   returns a value of the Long data type  . It is an integer in the range –2,147,483,648 to 2,147,486,647 . The Long data type is 4 bytes in memory. The function can also be used to convert a number stored […]

1. CInt VBA function – Description The CInt VBA function returns a value of the Integer data type . It is an integer in the range -32768 to 32767 . The Integer data type takes 2 bytes in memory and is therefore very efficient. This way, we can convert low-valued […]

1. CDbl VBA Function – Description The CDbl VBA function   returns a value with the Double data type  . It is a number between -1.79769313486232e +308 to -4.94065645841247E-324 . The Double data type is 8 bytes in memory. We usually use functions when converting very large floating point numbers. Using […]

1. CDate VBA Function – Description The CDate VBA function   returns a value with the Date data type  . The Date data type is 8 bytes in memory. The function converts the date and time saved in text form to VBA formatted date and time. The function works like the […]

1. CCur VBA Function – Description The CCur VBA function   returns a value with the Currency data type  . It is a floating point number formatted as a currency ranging from -922,337,203,477.5808 to 922,337,203,685,477.5807 . The Currency data type is 8 bytes in memory. . Attempting to call a function […]

1. CByte VBA Function – Description The CByte VBA function returns a value of the Byte data type. It is an integer in the range 0-255 . The Byte data type, as its name suggests, occupies a memory space of 1B. This way, we can convert low-valued numbers to store […]

1. CBool ​​VBA Function – Description The CBool ​​VBA function returns a value of the Boolean data type, that is, True or False . We can use it to convert both the result of a logical expression and the number 1 or 0. The CBool ​​function can also be used […]

1. Year VBA function – Description The Year VBA function returns a number representing the year of a given date. So if we want Excel VBA to return to us numbers corresponding to subsequent years, we should use this function. It should be remembered that the date from which we […]

1. WeekdayName VBA Function – Description The WeekdayName VBA function  returns the word name of the day of the week from 1 to 7. It is important that the argument for this function is a number, not a date. The function can be combined with the VBA Weekday function or […]

1. Weekday VBA Function – Description The Weekday VBA function  returns the word name of the day of the week from numbers from 1 to 7. In the second argument of the function we can define which day of the week we consider as the first, e.g. for Poland it […]

1. VBA TimeValue Function – Description The TimeValue VBA function  converts the time stored in text form into a formatted time with the date data type in VBA. This function is also used to extract time values ​​from date and time values. If we would like to convert a text […]

1. TimeSerial VBA Function – Description The TimeSerial VBA function  returns the time composed of arguments such as hour , minute ,  second . If in VBA you have numbers representing hours, minutes, seconds and you want to compose time from them, use the TimeSerial function. In case you want […]

1. Now VBA function – Description The Now VBA function   returns the current date and time or the time only. If we want Excel VBA to return the current date, we should use this function. The Date function has no arguments. The time value from the Now function is the […]

1. MonthName VBA Function – Description The MonthName VBA function  returns the word name of the month from 1 to 12. It is important that the argument for this function is a number, not a date. The function can be combined with the VBA Month function . The function can […]

1. Month VBA function – Description The Month VBA function returns a number representing the month of a given date. So if we want Excel VBA to return the numbers corresponding to the following months, we should use this function. It should be remembered that the date from which we […]

1. Minute VBA function – Description The Minute VBA function returns a number representing the minutes for a given date and time. So if we want Excel VBA to return the numbers corresponding to the next minutes, we should use this function. It should be remembered that the date and […]

1. Hour VBA function – Description The Hour VBA function   returns a number representing the hour for a given date and time. So if we want Excel VBA to return to us numbers corresponding to the following hours, we should use this function for this purpose. Please note that the […]

1. Day VBA function – Description The Day VBA function returns a number that represents the day of the month of a given date. So if we want Excel VBA to return to us numbers corresponding to the next days of the month, we should use this function. It should […]

1. VBA DateValue Function – Description The DateValue VBA function  converts a text date into a formatted VBA date. The function is also used to extract the date value itself from a date and time value. If we would like to convert the time saved as text to serial time, […]

1. DateSerial VBA Function – Description The DateSerial VBA function  returns a date composed of arguments such as year , month , day . If in VBA you have numbers representing year, month, day and you want to compose a date from them, use the DateSerial function. In case you […]

1. DatePart VBA function – Description The DatePart VBA function  returns the individual parts of the date and time depending on the arguments entered. With its help, we can extract elements such as quarter, day of the year, week of the year, as well as standard date elements such as […]

1. DateDiff VBA function – Description The DateDiff VBA function  returns the difference between two dates. Depending on what we introduce in the function arguments, we can get the difference in days, months, years, weeks, quarters, hours, minutes, seconds, etc. Monday. In the English nomenclature it will be Sunday. 2. […]

1. DateAdd VBA function – Description DateAdd VBA function is the date or time plus or minus a specified number of time units. So if we want to enlarge the date by e.g. a certain number of days, months and years, we will use this function. We use this function […]

1. Date VBA function – Description The Date VBA function   returns the current date. If we want Excel VBA to return the current date, we should use this function. The Date function has no arguments. The date value from the Date function is the system date. You can compare the […]

1. Val VBA function – Description The Val VBA function   searches for occurrences of numbers in a string. If a number appears at the beginning of a string, the function returns its value in the form of a number with the Double data type. When a string starts with non-numeric […]

1. UCase VBA function – Description UCase VBA function converts all letters in a string to uppercase. You can compare it to the CAPITAL function in an Excel worksheet. How to use UCASE function in VBA Excel? In the argument of the function, enter a string in quotation marks, or […]

1. Trim VBA Function – Description The Trim VBA function removes spaces from both sides of the text. We use it when we want to remove unnecessary spaces from both the left and right side of a text string. It is worth noting that the function does not remove spaces […]

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 – Syntax StrReverse (Expression As String) As String Expression […]

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 . We can convert the string to lowercase like […]

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, [Compare As VbCompareMethod = vbBinaryCompare]) String1 : The […]

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 there are characters in a given text string. […]

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 – Syntax Space (integer) Integer  – The number […]

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 spaces from the left side of the text, […]

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 other text starting from the right side. For […]

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 can also determine how many occurrences of strings […]

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 “I’m learning to program in VBA, we can […]

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 middle of the text, we should use the […]

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 to the Length function in other programming languages. […]

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 other text starting from the left side. For […]

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 the function, enter a string in quotation marks, […]

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. This function can also be used to search […]

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 used to search for words in the text […]

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 position in an array based on a character, […]

1. Asc VBA function – Description The Asc VBA function   returns the position of a character in an ASCII character array . For example, the letter “a” is position 97 in the ASCII code table. If we would like to get a letter from the position in an array, we […]

1. Atn VBA function – Description The Atn VBA function   returns the arcustangent value. In order to calculate the arcustangent value, we should use this function. For example, arctan with 1 is Pi / 4. 2. VBA Atn function – Syntax 'officeinside.org Atn (Number As Double) As Double Number : […]

1. Tan VBA Function – Description The Tan VBA function   returns the tangent value. In order to calculate the value of tngens, we should use this function. For example, the tangent of 0 is equal to 0. 2. VBA Tan function – Syntax 'datatalk.pl Tan (Number As Double) As Double […]

1. Cos VBA function – Description The Cos VBA function   returns the cosine value. We should use this function to calculate the cosine value. For example, the cosine of 0 is equal to 1. 2. VBA Cos function – Syntax 'datatalk.pl Cos (Number As Double) As Double Number : The […]

1. Sin VBA function – Description The Sin VBA function   returns the sine value. In order to calculate the sine value, we should use this function. For example, the sine of 0 is equal to 0. 2. VBA Sin function – Syntax 'officeinside.org Sin (Number As Double) As Double Number […]

1. Sgn VBA function – Description The Sgn VBA function   returns the sign of the number specified in the argument. The function determines the sign, so it checks whether the argument is a negative, positive, or zero. In the case of a negative number, the function returns -1. For added […]

1. Sqr VBA function – Description The Sqr VBA function returns the square root of the argument with the Double data type. With this function we can calculate the root of the second degree. To calculate the root of a greater degree than the second, i.e. the root of the […]

1. Rnd VBA function – Description The Rnd VBA function   returns a random number between 0 and 1. The function can be compared to the RAND function in an Excel sheet. We use this function to randomize a number. The operation can be modified in any way to select a number from any range, eg from 0 to […]

1. Round VBA Function – Description The Round VBA function is used to round numbers with decimal places. How can I use the Round function? In place of the first argument of the function, enter the number you want to round. In place of the second argument, enter the number of decimal places to which […]