Sample Mind Map

Mer som dette

Calculus - Taylor and Maclaurin Series

Ved Michael Collins

DSS

Ved reham ashraf

Acid and Bases

Ved Muhd Nasrullah

Mindmap About Plastic

Ved Albert Vives

EXCEL-BVA

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

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

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

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

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.

TYPE OF DATA

CURRENCY

DECIMAL

LONG

STRING

DOUBLE

DATE

BYTE

SINGLE

INTEGER

BOOLEAN

VARIANT

OBJECT