The Ultimate Excel VBA Course: Learn & Master VBA Fast

Declare and use variables in VBA, applying naming rules (no leading numbers, no spaces), select types such as integer and string, and assign values with the equals sign using Dim.

Apply VBA variable practice by creating a sub in the Visual Basic Editor, assigning numbers and strings to range values, and testing with buttons linked to worksheets.

Master basic arithmetic in excel vba by declaring variables, performing addition and subtraction, and displaying results in cells through subs and macro buttons.

Explore multiplication and division in VBA using the asterisk and forward slash. Create multiply_underscore_practice and divide_underscore_practice subs, add buttons, assign macros, and view results on the sheet.

Explore VBA numeric variable types including integer, long, single, double, and currency, covering ranges, precision, and overflow, then test with message boxes to compare decimals and rounding behavior.

Master conditional logic with if statements in VBA by testing a condition to execute code between if and end if when true, skip it when false, using a message box.

Explore VBA if statements with else and elseif, using message boxes to display outcomes for ten, eleven, or other numbers, and learn how to test multiple conditions.

Master VBA conditional operators beyond equals sign to power if statements, using less than, less than or equal to, greater than, and greater than or equal to with ampersand concatenation.

Explore how boolean values and boolean variables drive VBA decision making, and master not, end, and or operators to build robust if statements in Excel VBA.

Learn to write a VBA sub that reads a score from cell b1, uses if and elseif to assign a grade in cell c1, and color-codes and centers the cell.

Learn to replace multiple if-elseif statements with a select case structure that evaluates a string variable and displays red, green, or blue messages via message boxes.

Learn the with and end with statements in excel vba to reduce repetition, speeding up code, by setting multiple active cell font properties (name, size, bold, color, italic).

Learn how Excel VBA uses built-in case functions to convert text to lowercase, uppercase, and proper case, with a sub reading from A2 and applying offset.

Master the Excel VBA replace function to swap text inside strings, using a test_replace sub and original_text and corrected_text to write results to worksheet cells.

Explore VBA string functions such as InStr, InStrRev, and StrReverse to search within strings, validate emails, and reverse text, using practical examples and conditional logic.

Discover how the left and right functions chop characters from strings in VBA, use inStr and Len to swap name order, and format surname, first name as Jones, David.

Master the mid function to extract characters from a string by specifying the string, a start position, and a length; learn with an email example and loop applications.

Learn to manipulate strings in Excel VBA to remove hyphens, convert PD to PDC, and assemble with left, mid, and concatenation. Then display the result in a message box.

Explore how the for loop in VBA executes code from start to end, iterates with next, sums values, and displays the final result in a message box.

Learn how to use a for each loop to iterate through the range a1 to a6 and through arrays, declare a variant cell value, and replace hyphens with nothing.

Learn to reference cells with the cells property and cells.item in VBA, loop from start number to end number, fill column a with start number times ten using offset.

Learn how to use the do while loop in VBA to iterate until the end condition, initialize and increment a counter, and write results to the worksheet.

Master arrays in VBA by declaring and initializing multiple values under one name, using zero-based or one-based indexes, and handling subscript out of range errors.

Master arrays and loops in VBA by storing numbers in an array, iterating with a for loop from 1 to ubound, and printing values to spreadsheet cells while handling lbound.

Master multidimensional arrays in Excel VBA by initializing 2D and 3D arrays, assigning values, and printing them into spreadsheet cells using a double loop.

Discover how the split function divides a string into substrings using a delimiter, stores them in an array, and how join reassembles them with a chosen separator.

Create and manage VBA subs in a new workbook, call one sub from another, and format the active cell font using a with statement while choosing public or private scope.

Learn how to pass values between subs in Excel VBA using parameters and the call statement, and use with to set font properties while validating input with is numeric.

Master how to customize message boxes in Excel VBA with the MsgBox function, using button options, icons, and returning the clicked button value.