VBA programming

VBA programming

1. Excel Form

   • Forms in VBA or forms in Excel are known as Userforms, they are used to perform operations such as the registration, update, deletion or processing of existing data in Excel, or as a user interface from which previously existing macros can be executed

2. Tool box

   • 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. Controls

   • Intrinsic controls are always included in the toolbox, not like ActiveX controls and insertable objects, which can be removed or added to the toolbox.
     • ComboBox
     • FileListBox
     • Checkbox
     • HScrollBar y VScrollBar
     • CommandButton
     • Data
     • DirListBox
     • DriveListBox
     • Picture
     • Label
     • ListBox
     • TextBox

4. object properties

   • Objects are the basis of Microsoft Visual Basic; Almost everything that is done in Visual Basic involves the modification of objects. All Microsoft Word elements (such as documents, tables, paragraphs, bookmarks, and fields) can be represented with Visual Basic objects.

5. type of data