EXCEL-BVA
TYPE OF DATA
OBJECT
VARIANT
BOOLEAN
INTEGER
SINGLE
BYTE
DATE
DOUBLE
STRING
LONG
DECIMAL
CURRENCY
TOOL BOX
The toolbox or vba toolbox is the section where we insert controls to our forms
It often happens that we erase some control of this picture or suddenly we do not see any control. And unless we remember what are the default controls that come, the best way to recover them is to reset them.
CONTROLS
By creating Userforms in Excel VBA, you can use the Controls collection to easily navigate the controls and set a property of each control to a specific value
FORM
The forms in VBA are not more than an Excel dialog box where we can place controls that will help us to request information from the user. We can place text boxes, tags, combined pictures, command buttons
CONTROL STRUCTURES
The control structures allow the repetition of certain actions.
One of the most common errors that occur in the use of loops of this type, is the non-initialization of the variables used as iteration counters, producing an error of not ending the loop
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