Excel 2010 VBA and Advanced (2-Course Bundle)

Explore the Excel object model, the VBA editor, variables, subroutines, functions, arguments, constants, control structures, user forms, and debugging to build robust Excel 2010 VBA macros.

Display the developer tab in Excel, set macro trust, and record your first macro, then explore the VBA editor, relative references, and ribbon customization to streamline coding.

Explore macro security in Excel 2010's Trust Center, covering four options from disable all macros without notification to enable all macros, including digitally signed macros.

Record your first macro in Excel, name it without spaces using Hungarian notation, set a shortcut, choose storage (personal macro workbook or new), and document the weekly status framework.

Explore the VBA editor basics by navigating the macros dialog, understanding project and properties windows, and using debugging tools like compile, breakpoints, and watches to master Excel automation.

Explore how to debug and manage Excel VBA macros in the editor, including running, pausing, breaking, and resetting code, configuring references, and adjusting editor options.

Explore the Excel 2010 object model, VBA fundamentals, and the difference between functions and procedures, with practical module creation and prefix organization.

Learn to declare variables with option explicit, create public or private subroutines, and distinguish subroutines from functions while testing with the immediate window and debugging with a breakpoint.

Learn how to declare variables in VBA with dim, choose types (string, integer, double, boolean), set object variables for a worksheet and a range, and understand defaults, errors, and commenting.

Understand VBA scope, from local variables to module-level private and public declarations, and how the immediate window helps inspect or change values across subs and functions.

Learn to manage VBA code with commenting techniques: use the apostrophe to comment lines, toggle blocks on and off, and test ideas without deleting code.

Explore defining constants in VBA, using const for immutable values like pi, and building a public function that calculates a circle area from a radius, returning a double.

Learn how to create public VBA functions in Excel, define and name arguments, and return values, using variables, constants, data types, concatenation, and scope to build solutions.

Understand how to use Excel VBA logical operators: equals, less than, less than or equal to, greater than, and greater than or equal to, and build nested if statements.

Learn how to replace nested ifs with a select case in Excel 2010 VBA, mapping values to very good, good, bad, and very bad, with one entrance and one exit.

Master for next loops in Excel VBA using an integer loop variable, active cell, and offset to fill rows or columns from 1 to 15, with stepping and exit for.

Explore a do loop in Excel VBA, starting at the active cell, using do until to reach 15, with manual increment, offset, and range considerations to avoid overwriting headers.

Master the while loop in Excel VBA, compare it with for next and do loops, avoid infinite loops, and use control break and saving practices to manage loop control.

Explore the object browser in the vb editor to access built-in excel VBA functions, including date and string utilities. Understand input box limitations and why you might avoid it.

Learn how the Excel 2010 VBA input box captures user input, assigns it to the active cell, and uses prompts with optional titles, noting no built-in validation.

Explore how the msgbox function in Excel VBA works as both a procedure and a function, customizing prompts, icons, and buttons for user interaction and debugging.

Learn to parse a full name into first and last names in VBA using left, instr, and mid, then trim spaces and normalize case with upper or lower, plus debugging.

Excel stores dates as serial numbers and offers date functions like day, month, year, weekday, date add, and date part; explore the object browser and message box for date handling.

Design a user form in Excel VBA to create an interactive interface with controls like dropdowns, text boxes, and images, and explore form properties and events.

Explore Excel VBA form controls such as label, text box, combo box, list box, checkbox, radio button, toggle button, frame, command button, tab strip, and ref edit, plus toolbox usage.

Explore setting up Excel VBA user forms: name, caption, modal behavior, startup position, and tag; and populate a worksheet list in a combo box using for each and add items.

Harness the Excel VBA object model to drive form properties and controls, update sheet titles via range values, and respond to events across multiple sheets.

Learn practical debugging techniques in Excel 2010 VBA, distinguishing syntax from logic errors. Master compiling, breakpoints, stepping through code, watches, and error traps to ensure reliable macros.

Learn how to set breakpoints in VBA to pause code and watch execution. Understand how breakpoints help test for loops and overflow errors in Excel.

Step through your macro with f8 to advance lines, monitor the active cell and i loop, and use the watch window to track expressions during debugging.

Learn to debug VBA in Excel by using watch expressions to break on conditions, monitor loop values, manage scope, and step through code efficiently.

Discover how to implement VBA error traps with on error goto, ensure one entrance and one exit, and use the error object, message box, and resume options for debugging.

Explore the Excel object model - application, workbook, worksheets, and range - along with the VBA editor, core concepts like variables, constants, procedures, functions, control structures, and debugging, plus user forms and auto filter.