Best Excel VBA and Macros Course - Beginners to Advanced

Open the Visual Basic Editor in Excel with F11. Learn how the Project Explorer, Property window, and Immediate, Watch, and Locals windows aid debugging and code execution.

learn how variables act as storage for data, using an Excel example of dollars and adjustable exchange rate, and how changing the amount or rate updates the calculation in VBA.

learn how to use the string operator with the and symbol to concatenate values, turning first name and last name into a full name such as Kalash Sharma.

Learn how VBA comparison operators work, including equals, not equals, greater than, less than, greater than or equal to, and less than or equal to, with x and y.

Explore comparison operators in Excel VBA by comparing two variables using equal, not equal, less than, greater than, and their variant forms, shown via if statements and message boxes.

Explore practical examples of sub procedures and functions in VBA by building a parameterized calculator, calling procedures, and returning values to display results.

Explore the Excel object model from application to workbooks, worksheets, and ranges, distinguishing sheets from worksheets and mastering fully qualified references and active sheet behavior.

Explores how to work with cells in VBA by reading and writing values, using the active cell, and displaying results with a message box, including ranges and formulas.

Learn to read cell values into VBA variables and write results back to Excel cells using Sheet1.Range.Value, then sum three numbers and debug line by line with F8.

Format a data range in Excel VBA by applying borders, bold header, blue fill, white font, and auto-fit columns across A1 to G19 using the sheet code name.

Explore how to work with worksheets in Excel VBA by reading the active sheet, switching sheets, adding and deleting sheets, and copying data between sheets using index-based destinations.

Learn how to work with workbooks in Excel VBA by opening, referencing ThisWorkbook, copying data between workbooks, pasting into a target sheet, and safely closing with save options.

Explore how to work with the Excel VBA application object, including closing the Excel application and retrieving the logged-in user name with Application.UserName, shown in a message box.

Explore the Excel application object in VBA, use the username property to identify the current user, toggle screen updating for faster formatting, and close the application.

Learn how to write if, if else, and else if statements in VBA using single-line and block formats, with practical examples for conditions, holidays, and multi-action blocks.

Demonstrates using an if statement in Excel VBA to check Sheet1 C3 with mod two, writing 'yes' to D3 for odd numbers and clearing D3 for even numbers.

Discover nested if statements in VBA, using if inside if to check multiple conditions such as maths, english, and science marks greater than 33, and navigate true and false paths.

this lecture demonstrates an excel vba example using nested if statements to verify english, maths, and science marks are above 33 to pass, otherwise fail, with an alternative using and.

Learn the select statement syntax and how to define cases to evaluate cell values or age. See how select case offers a structured alternative to if statements with practical examples.

Demonstrate a practical excel vba select case example that labels a day from C3 as either a holiday or a working day, using multiple and comma-separated cases.

Explore how the for loop repeats tasks using a counter and iterations, from counting one to ten to checking even numbers with mod. Learn how step increments customize loops.

master a practical for loop in excel vba to color male records yellow by looping through dynamic rows, checking gender in column d, and setting the interior color.

Use a for each loop to iterate through the workbook's worksheets collection and perform actions on each sheet. Inside the loop, protect each sheet with the password 1 2 3.

Use a for each loop to iterate through all worksheets, apply header formatting to A1:F1 with bold font and green fill, and add borders using end up to last row.

This lecture demonstrates a practical Excel VBA while loop that evaluates student marks in B to D against 33, assigns pass or fail, and colors the result green or red.

Learn how do while loops work in VBA, how they differ from while loops, and how to exit when a blank is found, with examples that accumulate sums.

Demonstrates a practical do while loop in Excel VBA to sort data, generate random numbers, and highlight values below 100 in yellow, with an early exit to boost performance.

Exits a do loop in Excel VBA using exit do, driven by a condition and user input. Demonstrates summing numbers until the user stops and a marks check for pass.

Explore the InStr function in Excel VBA to locate a substring using start position, string one, string two, and a compare parameter, including case sensitivity and text versus binary compare.

Watch a practical example that uses InStr and Mid in Excel VBA to extract each user's email id from text within a for loop.

Learn how the StrReverse function reverses strings in VBA, then use InStr and Right to extract file extensions or last words from sentences.

Demonstrate using the StrReverse function in Excel VBA to extract file extensions by reversing the filename, locating the dot, and using Right to return the extension.

Learn how the LCase and UCase functions convert text to lowercase and uppercase in Excel VBA, with practical examples illustrating parameters and results.

Learn LCase and UCase functions in Excel VBA with a practical loop that converts column a to lowercase in column b and uppercase in column c.

Learn to extract date parts with left, mid, and right in Excel and convert them to dates using VBA with CDate, illustrating a loop over a us date format column.

Learn how the trim function removes leading and trailing spaces from a string, returning an updated string. Keep in mind that it does not remove spaces inside the string.

Learn how to clean data in Excel VBA by applying the trim function to remove leading and trailing spaces, ensuring accurate name counts and consistent results in macros.

Learn how the Len function in VBA counts characters, including spaces, with a string input, illustrated by an example where the length is 18.

Explore a practical example of the len function in Excel VBA, checking if customer names exceed 20 characters to determine label printing status and record results in column B.

This practical excel vba replace function demo shows looping to replace characters in a string on sheet1 a1, using search values from column e and replacements from column f.