OSWAL

Honelako gehiago

Concept Map 1

by Jason Vogt

ahmed hussain IT

by Ahmed Hussain Salih

Mathematics

by Desi McKeown

Google GCP ACE-2019

by Simon Erses

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