VISUAL BASIC

VISUAL BASIC

1. IT IS ONE OF THE PROGRAMMING LANGUAGES THAT MOST ENTHUSIASMO WAKE UP BETWEEN PC PROGRAMMERS, FOR EXPERTS AS NOVATOS. In the world of computer programming, one of the Most popular and known languages ​​is that of Visual Basic. Created in 1991 by Alan Cooper for Microsoft, this package allows to program graphic computer contents in a simple way and accessible. Visual Basic has been developed with the aim of providing users of computer programming a package of simple and accessible utilities. This is why the Visual Basic can be used and easily understood by experts as well as by users beginners Its base part of the BASIC dialect but with novel components that adapt it to modern computer languages. To this is added that Visual Basic is also a language of program driven by events that allows greater operability and better results.

   • ELEMENTS OF THE VISUAL BASIC
     • FORM
       • The forms in VBA are nothing more than an Excel dialog box where we can place controls that will help us request information from the user. We can place text boxes, labels, combo boxes, command buttons, etc.
     • TOOL BOX
       • Displays the standard Visual Basic controls, in addition to the ActiveX controls and plug-ins that you have added to your project.
     • CONTROLS
       • Controls and objects that can be added to them many, can facilitate data entry in spreadsheets and improve the appearance of spreadsheets. You can also do it yourself with little or no need for Microsoft Visual Basic for Applications (VBA).
     • PROPERTIES OF OBJECTS
       • Objects in Excel (VBA) are things. A cell is an object, a sheet is an object, a book is an object and in this way there are many more objects in Excel. We know this as the Excel object model.If a person were an Excel object their properties would be the color of their eyes, the color of their hair, their height, their weight. In the same way, an Excel object has properties by examples, a cell (Range) has the properties Value (Value) and Address (Address) among many others. These properties best describe the object.
     • TYPE OF DATA
       • A data type is the characteristic of a variable that determines what type of data it can contain.
         • Type conversion functions Boolean Byte Currency Date Decimal Double Integer Long LongLong LongPtr Object Single String Defined by the user Variant
     • CONTROL STRUCTURES
       • They are used to control the flow of the program in a routine or function.  These structures allow to control, by a condition, the execution or not of a line or set of lines of code.
     • APPLICATIONS AND PROGRAMS
       • Microsoft VBA (Visual Basic for Applications) is the Microsoft Visual Basic macro language that is used to program Windows applications and is included in several Microsoft applications. VBA allows users and programmers to extend the functionality of Microsoft Office programs. Visual Basic for Applications is an almost complete subset of Visual Basic 5.0 and 6.0. Microsoft VBA is integrated into Microsoft Office applications, such as Word, Excel and Access, Powerpoint. Practically anything that can be programmed in Visual Basic 5.0 or 6.0 can also be done within an Office document, with the only limitation that the final product can not be compiled separately from the document, sheet or database in which it was created; that is, it becomes a macro

2. bibliography

   • https://docs.microsoft.com/es-es/office/vba/language/reference/user-interface-help/toolbox https://exceltotal.com/formularios-en-vba/ https://support.office.com/es-es/article/informaci%C3%B3n-general-sobre-formularios-controles-de-formulario-y-controles-activex-en-una-hoja-de-c%C3%A1lculo-15ba7e28-8d7f-42ab-9470-ffb9ab94e7c2 https://exceltotal.com/objetos-propiedades-y-metodos/ https://es.slideshare.net/carolina00/estructuras-de-control-en-isual-basic https://excel.facilparami.com/2012/05/introduccion-a-vba-visual-basic-for-applications/