Here we will go through the basics in VBA programming. Everything from creating your first script to modify strings, numbers, or dates to working with arrays and messageboxes.
How to learn the basic operations in excel macro VBA?
Learn the basics in vba. How to modify, text, numbers, dates. Leverage if statements with loops and get the basic vba understanding.
VBA background and how we access our worksheet cells?
Learn why vba exists, its object based structure hierarchy and how to select worksheet and cells in different worksheet.
When to use a Sub vs a Function in VBA?
Learn how create scripts. Sub and function, as well as call on them by passing variables and data in between.
How to display message and input boxes in VBA?
Display message (msg) boxes and collect data with inputboxes. Ok, Cancel, Abort, Retry, Ignore, Yes No in different message styles.
How to work with IF statements in VBA?
Learn how to create different if statements that suits your needs. Great introduction to if-else- mindset.
How to work with and modify numbers in excel VBA?
Learn how to modify your numbers with vba. Addition, Subtraction, Division, Multiplication, Power, Exp, Modulo remainder.
How to work with and modify dates in excel VBA?
Modify your date formatting with vba. Date additions and subtractions, dateserial and datediff function as well as custom date formatting.
Create your first VBA script and learn how to declare variables
Learn how to declare your variables in vba. Necessary programming understanding and in order to be great in vba and to run quick scripts.
How to work with While and For Loops in VBA?
Learn how to iterate with different loops in vba. For loops, while loops, reverse loops, for each, double and multidimensional loops.
How to work with and modify texts (strings) in excel VBA?
Learn how to modify your texts with vba. Using syntaxes such as left, right, mid, split, instr, replace, trim, len, lcase, ucase, instrrev.
How to read a collection to array in vba?
Learn about reading and writing multidimensional arrays in vba, what they are, and how to work with them. Great for big data.
How to do: "for loop decrement vba"
Below we will find an example of how to decrement loop in vba, or so called reverse looping. It really works the same way as a normal for...
How to use "VBA split"?
This article will go through how to divide a word or sentence into multiple words in vba with the help of the "split" syntax.
How to use "VBA Vlookup" or "VBA Xlookup" ?
This article describes how to use vlookup syntax in excel vba.