VISUAL BASIC

VISUAL BASIC

1. Microsoft VBA is the Microsoft Visual Basic macro language used to program Windows applications and included in several Microsoft applications.

2. data types

   • Boolean
   • Byte
     • Single
   • Char
     • String
   • Date
   • Double
   • Decimal
   • Integer
   • Long
   • Object
     • SByte
     • Short

3. FORM

   • VBA forms are nothing more than an Excel dialog box where we can place controls that will help us to request user information. You can place text boxes, labels, combo boxes, command buttons, etc.
     • https://exceltotal.com/formularios-en-vba/

4. toolbox

   • Displays the standard Visual Basic controls, in addition to ActiveX controls and insertable objects that you have added to your project.
     • Label: Allows you to have text that you do not want the user to change, such as a caption under a graphic.
     • TextBox : Holds text that the user can either enter or change.
     • ListBox :Use to display a list of items from which the user can choose.
     • Select Objects: Is the only item in the Toolbox that doesn't draw a control.
     • CheckBox : Creates a box that the user can easily choose to indicate if something is true or false, or to display multiple choices when the user can choose more than one.
     • OptionButton : Allows you to display multiple choices from which the user can choose only one.
     • ToggleButton : Creates a button that toggles on and off.
     • TabStrip : Allows you to define multiple pages for the same area of a window or dialog box in your application.
     • MultiPage : Presents multiple screens of information as a single set.
     • CommandButton : Creates a button that the user can choose to carry out a command.
     • ComboBox: Allows you to draw a combination list box and text box
     • Frame : Allows you to create a graphical or functional grouping for controls.
     • Image : Displays a graphical image from a bitmap, icon, or metafile on your form.
     • SpinButton : A spinner control that you can use with another control to increment and decrement numbers. Y
     • ScrollBar : Provides a graphical tool for quickly navigating

Bilder und Dateien der Mindmap