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 […]
excel
98 posts
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 […]
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 […]
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 […]
Insert Multi Page tabs into the UserForm VBA MultiPage Contol are pages of your application, between which the user will be able to jump. On each page you will see other elements and content of the application. To insert pages into our UserForm, you should choose the MultiPage control from the ToolBox. […]
How to build an application in Excel VBA using the UserForm form In the last part of the course we will deal with the creation of a short application using the form. As in the case of the previous application, we should write down the basic requirements based on which our […]
What is VBA UserForm The UserForm form is a form that works under Excel that allows us to create visually developed applications. You can add more types of controls to the UserForm form than to the data sheet. From the controls of the UserForm form, we can distinguish primarily: Label label TextBox […]
How to insert VBA CheckBox control in Excel Sheet (ActiveX control)? How to use VBA Check Box ? You can embed this control in Excel in the same way as the option buttons. The important thing compare to the VBA option button is that you can select more than one option using Check […]