Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Arrays and the Split Function
This video explains the split function where the string will be split into substrings using a delimiter. This clip is from the chapter "Arrays" of the series "The Ultimate Excel VBA Course - Learn and Master VBA Fast".This video explains...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Multidimensional Arrays
This video explains multidimensional arrays, which are made by adding a comma after the first number between round brackets of your array name, then adding another number. This clip is from the chapter "Arrays" of the series "The...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Cell Property
This video explains the Cell property used to reference the cells on your spreadsheets. This clip is from the chapter "Loops with VBA" of the series "The Ultimate Excel VBA Course - Learn and Master VBA Fast".This section explains loops...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Logical Operators
This video explains logical operators in VBA such as AND, OR, NOT. This clip is from the chapter "VBA Conditional Statements" of the series "The Ultimate Excel VBA Course - Learn and Master VBA Fast".This section explains the various...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Message Box
This video explains the message box or the msg box in Excel VBA. This clip is from the chapter "Subs and Functions" of the series "The Ultimate Excel VBA Course - Learn and Master VBA Fast".This section explains subs and functions in VBA.
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Subroutines
This video explains a subroutine, which is a piece of code that performs a specific task described in the code but does not return a result or value. This clip is from the chapter "Subs and Functions" of the series "The Ultimate Excel...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Arrays and Loop
This video explains how to store some numbers in an array and then use a loop to print the amount of cells in the spreadsheet. This clip is from the chapter "Arrays" of the series "The Ultimate Excel VBA Course - Learn and Master VBA...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Arrays
This video explains arrays where you can store more than one value under the same name. This clip is from the chapter "Arrays" of the series "The Ultimate Excel VBA Course - Learn and Master VBA Fast".This video explains arrays, loops,...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Do Loop
This video explains the Do Loop that allows the user to repeat a certain process in a macro. This clip is from the chapter "Loops with VBA" of the series "The Ultimate Excel VBA Course - Learn and Master VBA Fast".This section explains...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - For Each Loop
This video explains the For Each loop that is normally used with collections and arrays, which helps you run one or more loops to cycle through. This clip is from the chapter "Loops with VBA" of the series "The Ultimate Excel VBA Course...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - For Loop
This video explains the For loop that enables you to loop through a range of cells with just a few codes lines until the condition is met, and the code moves onto the next line of code. This clip is from the chapter "Loops with VBA" of...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - String Exercise
This video explains an exercise where you have a product code on a spreadsheet that is in the wrong format, and you have been given certain conditions as to how the output should look like after applying all you have learnt in this...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Mid Function
This video explains the mid function, which is used to grab characters from a string of text; it has three parts: the string to search, the starting position, and the number of characters to grab. This clip is from the chapter "String...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - The Left and Right Functions
This video explains the left and right functions, which will help us chop a string. The left function will help chop the characters from the start of the string and the right function will help chop the character from the end of the...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - InStr, InStrRev, and StrReverse
This video explains Instr and InstrRev, where Instr is looking from the start to the end, while InstrRev is looking from the end of the string to the beginning. The StrReverse returns a string by reversing the original string supplied....
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Excel VBA Replace
This video explains how to use the replace function to change the incorrect word. This clip is from the chapter "String Functions" of the series "The Ultimate Excel VBA Course - Learn and Master VBA Fast".This section explains strings in...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Trim, Len, and Space
This video explains three different functions: Trim, which is used to trim unwanted space from the text; the Len function is used to get the number of characters the string has; and the Space function is useful for formatting output and...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Changing Case
This video explains L case or U case; as the name suggests, these are used to change the letters into lowercase or uppercase. This clip is from the chapter "String Functions" of the series "The Ultimate Excel VBA Course - Learn and...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - With and End With
This video explains a new object called With and End With, where you can perform a series of statements on a specified object without specifying the name of the object multiple times. This clip is from the chapter "VBA Conditional...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Select Case
This video explains select case statements, which is an alternative way to write If and Else if statements and help you have a more understandable code. This clip is from the chapter "VBA Conditional Statements" of the series "The...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - VBA Practice Conditional Operators
This video is a practice session on conditional operators where if a person scores 85 and above, we will want to grade an A along with changing the background color of the cell. This clip is from the chapter "VBA Conditional Statements"...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Conditional Operators
This video explains the various conditional operators such as =, <, >, <=, >=, <>, and so on. This clip is from the chapter "VBA Conditional Statements" of the series "The Ultimate Excel VBA Course - Learn and Master VBA Fast".This...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Else and ElseIf
This video explains Else and ElseIf variables in Excel VBA using an example where you can add an Else part that tells VBA what happens if the opening line returns False. This clip is from the chapter "VBA Conditional Statements" of the...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - If Statements
This video explains If statements in Excel VBA using an example where if the input is less than 10, the condition will be satisfied or else it won't show an output. This clip is from the chapter "VBA Conditional Statements" of the series...