948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step 91 - VB or Visual Basic Editor

Visual Basic History

Basic

Visual Basic

VBA

VB.net

ASP

VBS
New coding language for phones

>

Let's go to the Visual Basic Editor

There are 4 commonly used windows in the VB Editor

Code
Properties
Project
Immediate

The VB editor uses a menu followed by the toolbar.

menu.png

Option Explicit

Project Window

This is where you manage the VBA code for each Excel File.

It's organized into 4 groups

Microsoft Excel Objects - contains code for Sheets and entire WorkBook (ThisWorkbook)

Forms - Dialogs you can create to get structured input from the user.

Modules - General code that you can organize, import, or export

Classes - allows you to build your own objects that support methods and properties

You can show/hide them by clicking the [+] or [-] items

On the Properties Window, you right-click to see a pop-up menu that allows you to insert a new Module.

What is a Module?

Name

Scope

Usually connected routines

Can be imported or exported (bas file)

You show/hide the Project Window via View > Project Explorer or Ctrl R

Structure



Excel --< WorkBooks -- VBA --< Modules --< Sub/Functions --< Lines of code

                        |

                         ----< Forms --< controls (ex. textbox, Label, combobox, listbox, buttons...)

                        | 

                        -----< Objects (Sheets) --< Cells ...

                        |

                        |                 |

                        |                 -------< Events ...

                        -----< Classes

Personal.xlsb