How to learn the basic operations in excel macro VBA?

Updated: Feb 3, 2021

This page will go through the basic VBA concepts and operations.

Please ​click on any of the headings below to get a better understanding of why excel macros are such a powerful programming language despite its age. Most of the code can be copied over to your own excel VBE which is why I tend to use the apostrophe (') and a green colored text, which signifies commented code in your VBE editor as well.

Background about VBA.

  • What is VBA and how can I use it?

  • ​Object based structure

  • Hierarchy

  • Accessing Ranges or Cells to write our data?

Create a VBA script​

  • ​Here we will create your first VBA script.

  • Declaration

  • Msgboxes​

​​

Sub or Functions​

  • Our two different ways to write scripts in VBA.

  • When to use which?​
     

Message boxes​

  • Displaying information on your screen.

  • Message box vs Immediate window.

  • Input boxes.
     

IF statements​

  • What is an IF statement?

  • Examples with different IF statements.
     

Loops

  • What are loops​​?

  • Different types

  • How to leverage loops with IF statements?
     

String manipulation​

  • How to ​modify strings.
     

Number manipulation

  • How to modify numbers.​
     

Date manipulation

  • Use of dateformat.

  • Modify Dates.

  • Custom dateformats
     

Array manipulation

  • How to Modify Arrays.​

    260
    0