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 […]
Cos VBA function – Description The Cos VBA function returns the cosine value. You should use this function to calculate the cosine value. For example, the cosine of 0 is equal to 1. VBA Cos function – Syntax 'officeinside.org Cos (Number As Double) As Double Number : The number on […]
Sin VBA function – Description The Sin VBA function returns the sine value. In order to calculate the sine value, you should use this function. For example, the sine of 0 is equal to 0. VBA Sin function – Syntax 'officeinside.org Sin (Number As Double) As Double Number : The […]
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 eual to 0. In the case of negative number, the function returns -1. For positive […]
Sqr VBA function – Description The Sqr VBA function returns the square root of the argument in the Double data type. With this function you can calculate the root of the second square 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 generate random numbers. The operation can be modified in any way to select a number from any range, ie. from 0 to […]
Round VBA Function – Description The Round VBA function is used to round numbers with decimal places. How can we 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 you […]
CMD Shell in VBA Excel – what it is and how to use it In this article you will learn how to control other Windows programs from Microsoft Excel using VBA code. If you are trying to do any action in Windows using Excel, the most of these actions are used […]
Table of Contents VBA Error handling – How to use it? VBA error handling – Error Handling Resume Next GoTo Line GoTo 0 VBA Error handling – How to use it? In this article you will learn what VBA error handling is and how to use it correctly. In VBA, as […]
VBA conversion functions – Description. How to change data type in VBA Excel? In this chapter, you will learn all convertion functions in Excel VBA . When writing programs in VBA, you will have often a situation where you will have to change the data type. As you probably know, […]
Table of Contents VBA Arrays – basic informations What are arrays in VBA Excel – VBA Arrays Declaring and addressing elements of the array in VBA Declaring an array with total number of elements: Declaring an array with the specification indexes of elements: Mixed declaration of an array Change in […]
How to write an Excel add-in using VBA? Creating a simple add-in in Excel VBA is all about writing a good VBA code. In this article you will learn how to do an Excel add-in. The add-in will do the following action: Opens the file saving window and inserts the […]