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
Accessing Ranges or Cells to write our data?
Create a VBA script
Here we will create your first VBA script.
Sub or Functions
Our two different ways to write scripts in VBA.
When to use which?
Displaying information on your screen.
Message box vs Immediate window.
What is an IF statement?
Examples with different IF statements.
What are loops?
How to leverage loops with IF statements?
How to modify strings.
How to modify numbers.
Use of dateformat.
How to Modify Arrays.