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.
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.
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 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 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.
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...