Master Microsoft Excel VBA and Macros: Beginner to Advanced

Learn how to use Excel VBA to automate tasks with macros, create and manage modules, and write subs in the Visual Basic Editor using Project Explorer and the Properties Window.

Start macro programming using input box and message box prompts, practice variable usage, and display personalized greetings. Run and test macros with F8 and control+space shortcuts.

Master Excel VBA and macros teaches building a basic macro that collects first and last names, builds a hello sentence, and shows it in a message box.

Master Excel VBA and Excel macros: learn to select multiple cell ranges, distinguish between a selection and the active cell, and use range concepts to build precise selections.

Format through VBA shows how to select a range, use the active cell to apply formatting, and apply colors via RGB to the chosen cells with a macro.

Explore using the end command in VBA to reach the bottom or far right of a worksheet by navigating range objects, selecting data, and applying offsets.

Explore offset in VBA to move within a worksheet, select ranges, and highlight cells using positive and negative row or column offsets, for Excel VBA and macros.

Create and run an Excel VBA macro to automate data entry, prompting for age, salary, and three inputs, placing them in cells and auto-incrementing the serial number.

This lecture shows a basic vba workflow: select a sheet, use offset to add a new row, and collect name and age via input boxes, creating an automatic serial number.

Explore how to refer to worksheets and chart sheets in Excel VBA, using sheet names and index numbers, with practical examples of activating and selecting sheets.

Explore VBA sheet management: rename sheets, refer by name or index, add or delete sheets before or after a target, and control protection, visibility, and counts with message boxes.

Learn to build an Excel VBA macro that creates a new sheet, prompts for a name, places it at the end, and clears it for reuse.

Master Excel VBA and Excel macros teaches you to create a new sheet after the last one, name it, and use the last sheet index to automate sheet tasks.

Explore three methods to refer to workbooks in VBA, see how to activate and switch between workbook objects, and use workbook references inside functions.

Explore workbook methods in Excel VBA by creating new workbooks, naming and saving Excel files, adjusting sheet properties, and closing workbooks while tracking unsaved changes.

Create a VBA macro that prompts for a new workbook name, copies the existing workbook's first sheet into the new file, and saves and closes it.

Define and use declared variables in Excel VBA, enable option explicit, and learn naming rules, type checks, and debugging to prevent undeclared variables.

Learn data types for variables in Excel VBA and macros, including byte, long, double, date, date time, boolean, text, and object, and how they affect storage space and use cases.

Create a new sheet, name it with your own name, set its position, then go back to the function sheet to copy and paste it, and run the macro.

Explore a project solution that demonstrates creating and naming a new worksheet, storing it in an object variable, and referencing the sheet and its range in VBA.

Create a macro that prompts for a student name, locates it on sheet 1 with find, selects the matching cell, and displays the score 75 in a message.

Learn to use an if statement in VBA to classify scores as fail, pass, or compartment. Use thresholds below 40, 40 to 60, and 60 above with a message box.

Learn how and and or work in VBA to handle multiple conditions in a macro, using score rules such as more than 40 in tests and the final exam.

Learn to use a button to trigger a macro that creates new sheets, guided by macro recording. The lesson covers handling different sheet counts and adding more sheets as needed.

Learn to implement an if statement in Excel VBA, test conditions such as less than or equal to, read variables, and trigger actions with a button macro.

Learn to implement select case in VBA to replace complex if logic, categorize scores, store results in variables, and build reusable functions.

Explore how to use select case with range conditions in VBA, handling between 65 and 80 or 90 to 100, and compare efficiency with nested if statements.

Explore Excel VBA macros with Select Case to classify months into seasons, identify date ranges, and display messages using the Month function and message boxes.

Learn how loops automate repetitive actions in excel vba by stepping through cells and applying simple changes, and use stop conditions or undo to halt a running macro.

Practice loop-based conditional formatting in Excel VBA by highlighting scores under 15 in rosy brown and scores above 50 in yellow-green across a range from start to end.

Explore loop-based VBA tasks by reading a sheet, selecting data ranges, applying offset and index logic, and enforcing conditions with a 40 threshold to control macro flow.

Master the do while loop in Excel VBA, compare it with other loop constructs, and learn how conditions like not equal and equals control loop execution.

Master using a for loop counter in excel vba to iterate cells, apply if–then conditions, and produce clear outputs. Learn how to update indices and variables for reliable results.

Explore for loop counter steps in excel vba, from 1 to 174, how different step values affect loop flow, and a practical task to delete all sheets.

Explore for loop counter step techniques to iterate through workbook sheets, handle references, and safely delete or recreate sheets by reversing the loop to avoid omissions.

Discover how to use a for each loop to protect all worksheets in a workbook with single password. Collect the password from the user and apply protection to every sheet.

Learn how to use a for each loop to iterate over open workbooks in Excel VBA, close unwanted workbooks, and apply conditional logic to selectively keep or close books.

Explore a for each task solution to delete all sheets in a workbook in one go, while excluding a specific sheet using Excel VBA macros.

Master Excel VBA and macros show how to use a loop to apply conditional coloring across the entire data set, using values like under 50, 20, 30–60, and over 65.

Apply a for each loop across a defined range to automate data processing in Excel VBA, create new sheets, and distribute results to compartments and related tabs.

Master a loop related project in Excel VBA and macros by automating sheet selection, range manipulation, offset-based data transfer, and copy-paste to organize results.

Explore Excel VBA events, including workbook opening, before-close, and other actions like new sheet creation, double-click, and right-click, with message boxes, time-based cancellation, and auto-save.

Explore how to use Excel VBA and macros to trigger actions, display message boxes, and interact with sheets and objects through practical examples.

Practice handling a right-click event in Excel VBA by prompting for a password, validating a stored variable against the value 1, and showing an error message if it’s wrong.

Explore excel vba sheet specific events using the selection change event on the range, color cells green when values exceed 90, and set a default password 1 2 3 four.

Learn how to create your own user-defined function in Excel VBA, apply it to date formatting, and explore basic examples to format dates and compute age.

Students learn to create a simple Excel VBA function named precision to compute asset value, using current and selling price to determine the position value for a fixed asset.

Learn how to create an optional parameter in a VBA function, with last parameter optional by default, and handle default values and data types in Excel VBA macros.

Enable the Outlook object library in Excel VBA and send mail using Outlook application, composing subject, body with signature, and attaching files.

Explore how to automate Outlook mail from Excel using VBA: select and modify cells, set subject lines, and send emails step by step, handling large data sets.

Create and customize an Excel VBA userform, configure text boxes, combo boxes, and spin buttons, and wire controls with code to populate data on worksheets.

Master the pivot table with VBA by automating the source data range, caching data, and generating a new sheet via a macro.

Learn to use the File System Object in VBA to create and copy folders and files, handle existence checks, and control overwriting with Microsoft scripting runtime references.

Learn to use the file system object in VBA to copy a file, set destinations, and inspect file properties such as name, extension, size, and path via the immediate window.

Explore a practical fso example in vba to create a folder reference, list and iterate through files, filter by extension, and copy selected files to a destination.

Master late binding in macros to run without active libraries, contrasting with early binding, and learn how to manage object libraries and references for end users.