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.

Automate tasks by recording macros and subroutines, including formatting negative numbers, adding data entries, cleaning data tables, and using form controls with absolute or relative references to adjust charts.

Learn to record a macro in Excel to format negatives as red using a selected data range, edit the VBA module, and assign a custom shortcut for quick reuse.

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 writing efficient Excel VBA macros with the Excel object model and with blocks, using a recorded macro to format cell A1 to Calibri 18 point.

Explore how Excel VBA enables automation, from macros recording to writing efficient code that handles dynamic ranges and worksheets using modules and targeted cell operations.

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.

Record a macro to copy data from columns f to m, then open the Visual Basic editor to inspect the subroutine and understand how macro recording captures steps.

Create and run a VBA macro that copies a range (f1 to f40) and pastes it to N1, while using sub procedures, indentation, and stepwise execution for debugging.

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.

Copy data to the bottom of a range using dynamic ranges in Excel VBA, find the last row, and paste from a central repository across sheets for consolidation.

Learn how to use the Excel VBA find method to locate a value in a moving range, avoiding loops, trap the column index, and build dynamic ranges for data manipulation.

Learn to replace data quickly in Excel with VBA by targeting the current region and using a replace call to swap terms like motorcycle rider with motorcyclist.

Discover how to use Excel's special cells to identify blanks and delete entire rows with VBA, including dynamic ranges, sheet references, and recording macros for practice.

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 VBA language elements such as sub procedures, variables, strings, dates, option explicit, syntax, and expression entry, with practical examples building on macros, ranges, find and replace, and special cells.

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.

Learn VBA syntax and expression entry, mastering the order of operations, parentheses, exponentiation, and left-to-right evaluation, plus string concatenation and a practical present value example in Excel VBA.

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

Explore subprocedure concepts by recording or manually creating a subprocedure in Excel VBA, using the Visual Basic editor, module creation, and triggering via run options or a button.

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.

Define constants and static variables in VBA to persist values across subroutines; constants cannot be overridden, while static variables retain their value as long as the workbook is open.

Define object variables in Excel VBA and manipulate worksheet objects by declaring a worksheet variable, assigning a sheet, and changing its tab color with VB red or blue.

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 and use constants in Excel VBA to store values that never change, name them for readability, and reference predefined constants across modules when necessary.

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.

Declare variables and constants, perform calculations with built-in operators, traverse a five item array, and declare an object variable in VBA; prepare, edit, and test using cookie project file.

Demonstrate declaring a currency variable with dim, displaying it in a message box, performing division, looping a zero-based five-item array, and setting a worksheet object.

Explore the Excel object hierarchy in VBA by examining objects, properties, methods, and events, with the range object as a core example across workbooks, worksheets, and charts.

Master the vba range object, its properties and methods, and learn to reference single cells, rows, columns, and noncontiguous ranges across worksheets and workbooks.

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.

Explore essential Excel VBA range properties, including value, text, count, column, row, address, and formula. Learn reading and writing values, handling multi-cell ranges, and inserting formulas with examples.

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 VBA subroutines with practical examples that fetch input from an input box, the active cell, or a fixed range, and output results to a message box or range.

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.

Learn to handle basic user errors in VBA subroutines by using an error handler, validating input, and showing messages while converting gallons to cubic feet.

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.

Automate sorting in Excel VBA using a worksheet change event triggered by the F1 cell, sorting ascending or descending based on the changed target.

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.

Create a user defined function in Excel using VBA to compute cone volume from radius and height, including module setup, double arguments, and pi via arctangent.

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.

Learn to use built-in VBA functions with practical examples, including a message box display and date, today, month, month name, and length function.

Explore how to access Excel's worksheet functions from VBA using the WorksheetFunction object on the Application object, enabling functions like max, large, and pmt in your procedures.

Discover how VBA macros control program flow, skip statements, repeat actions, and test conditions using essential programming constructs, previewed and explained in this introduction.

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.

Learn how for-next loops drive repetition in VBA, control with a counter, sum numbers from 1 to 1000, use step values, and exit for early termination.

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.

Explore extending if statements and looping in VBA, then optimize with an autofilter to color cells not in the Northern Territory without loops, highlighting efficiency in Excel macros.

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.

Build a VBA do loop that uses Randbetween to pick a number between 1 and 10, prompts guesses with an input box, exits on correct guess, and shows congratulations message.

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.