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.

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.

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.

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.

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.

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.

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.

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.

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.