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.
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 and modify multidimensional arrays 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 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.
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 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 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 IF statements in VBA?
Learn how to create different if statements that suits your needs. Great introduction to if-else- mindset.
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.
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.
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.