How to use arrays in vba excel.

This article describes how to use vlookup syntax in excel vba.

This article will go through how to divide a word or sentence into multiple words in vba with the help of the "split" syntax.

Learn how to search through words in 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...

Learn how to declare your variables in vba. Necessary programming understanding and in order to be great in vba and to run quick scripts.

Learn about reading and writing multidimensional arrays in vba, what they are, and how to work with them. Great for big data.

Modify your date formatting with vba. Date additions and subtractions, dateserial and datediff function as well as custom date formatting.

Learn how to modify your numbers with vba. Addition, Subtraction, Division, Multiplication, Power, Exp, Modulo remainder.

Learn how to modify your texts with vba. Using syntaxes such as left, right, mid, split, instr, replace, trim, len, lcase, ucase, instrrev.

Learn how to iterate with different loops in vba. For loops, while loops, reverse loops, for each, double and multidimensional loops.

Learn how to create different if statements that suits your needs. Great introduction to if-else- mindset.

Display message (msg) boxes and collect data with inputboxes. Ok, Cancel, Abort, Retry, Ignore, Yes No in different message styles.

Learn how create scripts. Sub and function, as well as call on them by passing variables and data in between.

Learn why vba exists, its object based structure hierarchy and how to select worksheet and cells in different worksheet.

Learn the basics in vba. How to modify, text, numbers, dates. Leverage if statements with loops and get the basic vba understanding.