VISUAL BASIC

VISUAL BASIC

1. FORM

   • VBA forms are nothing more than an Excel dialog box where we can place controls that will help us request user information.

2. CUADRO DE HERRAMIENTAS

   • It shows the standard Visual Basic controls, in addition to the ActiveX controls and the insertable objects that you have added to your project.

3. PROPIEDADES DE LOS OBJETOS

   • DateString Returns or sets a String value that represents the current date according to the system. Now Returns a Date value that contains the current date and time depending on the system. ScriptEngine Returns a String that represents the runtime currently in use. ScriptEngineBuildVersion Returns an Integer that contains the build version number of the runtime currently in use. ScriptEngineMajorVersion Returns an Integer that contains the main version number of the runtime currently in use. ScriptEngineMinorVersion Returns an Integer that contains the secondary version number of the runtime currently in use. TimeOfDay Returns or sets a Date value that contains the current time of day according to the system. Timer Returns a Double value that represents the number of seconds elapsed since midnight. TimeString Returns or sets a String value that represents the current time of day according to the system. Today Returns or sets a Date value that contains the current date depending on the

4. ESTRUCTURAS DE CONTROL

   • The IF structure is used to make different sentences based on a condition. The conditions must be elements to evaluate whose result can be True or False. For the conditions the comparison symbols are used: Terms: 7 = 2 + 5 ------------> True 2 = 3 -----------------> False 5> 2 ------------------> True 5> = 3 ----------------> True 3 <3 -----------------> False 5 <= 3 ------------------> False 10 <> 10 ---------------> False = > > = < <= <> Equal Higher Greater or equal Minor Less or equal Different

5. Tipos de Datos en VBA

   • All values ​​that need to be manipulated in a program can be stored temporarily in a variable
     • the variables are those that must belong to a type of data, where the type of data determines the range of values ​​or set of values ​​that said variable could use.
       • There are 12 different types of data with which you can work
         • For example, when declaring a variable in VBA, just add a line of code to define the nature of the values ​​that we will store in it.