Microsoft Excel VBA Programming & Excel Macros for Beginners

Learn to record macros in multiple ways, run them, and assign them to a custom button, while exploring the personal macro workbook, VBA code, and absolute versus relative references.

Run and test macros from the developer or view tabs, enable content when prompted, record a macro and name it, then assign it to a button, shape, or image.

Record a macro to transfer data from the entry sheet to the database sheet, using paste special values and number formats with transpose, and assign it to a button.

Learn to clean and format a data table with Excel VBA macros, including splitting names into first and last names using text to columns and converting text to numbers.

Master absolute, relative, and mixed referencing modes in Excel VBA macro recording. See how each mode records formatting and column operations, and how the starting cell affects results.

Explore the developer tab in Excel to access the Visual Basics editor, record and edit macros, adjust macro security settings, and insert form or ActiveX controls for automation.

Master dynamic ranges in Excel VBA by using a last row variable to adapt ranges as data grows. Declare variables with option explicit and debug with the locals window.

Learn why option explicit matters in vba by declaring all variables with dim, catching spelling errors, and enabling automatic variable declaration in the editor.

Master VBA debugging by stepping through code with F8, using the locals window to inspect variables, and leveraging breakpoints, watches, and run-to-cursor to troubleshoot macros.

Explore the basics of Excel VBA data types, learn to declare variables and assign types, and understand byte, boolean, integer, long, single, double, currency, decimal, date, object, and variant.

Master VBA syntax and expression entry with concatenation, range references like C3, and if statements using relational and logical operators to control flow.

Create and execute sub procedures in VBA, prompt for a number, display its square root in a message box, and assign the macro to a worksheet button.

Explore how variables store text, numbers, and dates in VBA, with clear naming, data types, and scope rules; learn to declare variables, use option explicit, and track values across procedures.

Master variable scope in Excel VBA by declaring variables in the module declaration section to share across multiple subroutines, and distinguish procedure-level scope from module-wide accessibility.

Explore strings and dates in Excel VBA, including fixed and variable length strings and dim declarations. Use date add to calculate dates and display years with a message box.

Discover how VBA assignment statements use the equal sign as an operator to assign expressions to variables or objects. Learn modulo arithmetic with mod, operator precedence, and a practical example.

Declare a VBA array with dim to store lists of same-type values and access elements by an index in parentheses; use option base 1 for one-based lower bounds.

Master using the cells property to reference a single cell, a multi-cell range, or all cells on a worksheet by row and column numbers, and clear contents as needed.

Master range methods in VBA, including select, copy and paste, clear contents, clear formats, and delete, with techniques to activate the correct sheet and use the go to method.

Master Excel VBA subroutines by squaring a selected cell into A1, counting selection rows and columns with a message box, and using input with active cell offsets.

Excel VBA subroutine examples show how to add a user input x to the value in A1, compute a sum, and place the result in a user-specified range.

Explore sorting and filtering with Excel VBA, learn to record and optimize macros, and apply auto filter to segregate data into partial sets and consolidate updates across a workbook.

Record a macro to sort data with VBA, then adjust the code to sort by the actual column in ascending or descending order using the current region.

Implement a VBA sort toggle for ascending and descending using 1 and 2, with a data validation list in F1. Use a dynamic range starting at A2 and extending down.

Apply and customize Excel VBA auto filter to filter by region, blanks, and constants using the first field, with macro recorder for quick replication.

Learn to apply and turn off Excel VBA auto filters on a single column, using column B, and reference the worksheet code name with active sheet.auto filter mode = false.

Create a custom or user defined function in VBA to calculate commissions from sales and rate, then use it in a worksheet formula with absolute references.

Learn to convert a user-defined function for cone volume into an Excel add-in, save it as Coneval, and enable it in any open workbook via the add-ins manager.

Explore custom function examples in Excel VBA, including a square root function used in a worksheet formula, via a module and message box display, with access to user defined functions.

Learn how to borrow Excel functions in VBA, like count, count a, sum, average, min, max, sum if, and count if, using worksheet functions that adapt to dynamic sales sheets.

Explore the if-then structure in VBA, using conditional statements, else blocks, and end if to decide pass, fail, or distinction scenarios and extend to and/or and select case logic.

Master a basic for loop in Excel VBA by counting from 1 to 5 and writing the index into cells H1 to H5 using a simple subroutine.

master advanced looping in Excel VBA by trapping the last row, iterating from row two to last, and coloring NT cells using a for loop and if statements.

Iterate through a selection versus a fixed range in Excel VBA to locate a name and a color and return their row numbers. Use validation dropdowns for names and colors.

Learn to implement for-next loops and for-each loops in VBA to find sevens in a selected range, output matching rows to column C, and reset results.

Create a VBA subroutine that loops through a column to replace -998 and -999 with blanks, using a for loop or active cell approach to demonstrate macro techniques in Excel.

Learn to implement a VBA sub that sorts a vector in ascending order using the bubble sort algorithm, with step-by-step pairing and swapping in Excel.

Learn to iterate through an array of data using a range-based approach in Excel VBA, calculating min and max sales and highlighting them in red and blue.

Master VBA repetition structures in Excel with general do loops, do while (pretest), and loop until (post test), including pretest and post test concepts and tips to avoid infinite loops.

Implement input validation using a do loop to enforce a percentage input between 0 and 100, with corrective messages for out-of-range entries.

Explore how the go to statement in VBA changes program flow by jumping to labeled lines, including input box usage, and cautions about spaghetti code.