Project Based Excel VBA Course

Enable the developer tab from Excel options and access the Visual Basic editor to run macros. Save workbooks as macro-enabled or binary to run VBA scripts.

Navigate the VBA editor in Excel, learn to use the immediate, watch, and properties windows, insert modules, and debug with step into, toggle breakpoint, and run hotkeys.

Master dot notation in Excel VBA to access objects from application down to workbooks, worksheets, and ranges, then read or set properties and call methods.

Learn to write VBA code with ranges and cells, create a module and sub, assign values to cells, and combine range and cells for worksheet manipulation.

Master debugging in excel vba by diagnosing runtime and syntax errors in a tax return workbook, using breakpoints, watches, and step-by-step execution to locate and fix issues.

Explore extra VBA techniques in Excel: use named ranges and the resize property, apply worksheet functions, and determine last row or last column; finish with a practical VLOOKUP example.

Create three vba subs to build a battleship board in Excel, select the carrier, place the battleship with b characters in italics, and style the destroyer with borders and color.

Debug a VBA module in Excel using a watch window and step-through to identify incorrect calculations, then fix the multiply operator from ampersand to asterisk for the Battleship project.

Create a battleship game in Excel using VBA, starting with rules and project progression, transforming a workbook into interactive player versus computer play.

Create a new game module, clear log indicators and grids, reset attack flags to zero, and format the four grids on both player sheets with borders and center alignment.

Discover how to declare and assign variables in VBA using dim and the assignment operator, explore integer, double, string, and variant types, and work with option explicit and object ranges.

Master conditional logic in Excel VBA with if then, else if, and nested statements using weather and activity scenarios to decide supplies and actions.

Place and clear boats in an excel vba battleship exercise using variables and if-then logic, setting carrier and destroyer positions from six cells with borders and color indexing.

Implement battleship logic in Excel VBA by adding VBS no message box, defining six variables (player, enemy, hit, sunk, boat name, grid address), and displaying miss, hit, or sunk messages.

Learn to manipulate strings in Excel VBA with case functions, replace, trim and length, and use the end string function to locate text like the at symbol in email addresses.

Explore Excel VBA string handling with left, right, and mid, the like operator for pattern matching, and the is numeric function to distinguish numbers from text.

Build a VBA-based job application scanner that validates applicant data, checks date formats, computes education and qualification scores, and reveals whether the candidate is hired.

Explore loops in VBA, including for and for each, to automate tasks beyond Excel capabilities. Learn looping concepts, stepping, arrays, range handling, and practical examples like factorials and text trimming.

Learn how to implement do loops in Excel VBA, compare do while and do until, and apply cells and offset to iterate over ranges with practical examples.

Explore static and dynamic arrays in VBA, including declaration, bounds with lbound and ubound, redim, and preserve. Learn range assignments, looping, and faster data handling than sheet access.

Explore array functions in VBA, including multidimensional and nested arrays, dynamic and static arrays, and practical examples like filtering a grocery list and managing ranges.

Learn to insert headers above each unique item in a list using Excel VBA, by computing the last row, looping through data, inserting rows, and applying proper case.

Refactor the new game module in Excel VBA by looping through four grids to reset them, using a for loop and arrays for a leaner, easier to read implementation.

Implement the start game module's three VBA subs—populate log, find boats, and format boats—to validate player one boat placements, populate logs, and format boats on the grid.

Learn to check boat indicators, validate sizes, and populate player one boats on the grid in Excel VBA. Implement direction finding, address calculation, and error handling for a Battleship-style setup.

Format boats by looping through the boats table, clearing inner borders, setting none inside and continuous outside borders, and applying the color index from the player one boats range.

Create and call subs in vba to automate formatting expenses, including bolding and font adjustments, exploring direct execution, calling from another sub, and worksheet buttons, plus public versus private subs.

Learn how to pass values between subs in Excel VBA by using parameters, including optional parameters with defaults, by value and by reference, and handling ranges and variants.

Explore how Excel VBA functions differ from subs by returning values and requiring a data type, then define and call a function to assign bonus calculations to employees.

Build a medical form exercise in Excel VBA to copy data between low, middle, and high scenarios. Use named ranges and buttons to automate copying.

Connect subs and functions in the start game module, run for both players, populate logs, format boats, update enemy grids, and handle invalid boats before the fire shot module.

Explore the fire shot module, implementing target selection, hit/miss messages, and hunting logic using the hunting table to guide computer attacks on the enemy grid.

Learn to implement a find target function in Excel VBA that validates selection, computes top-left target coordinates on the enemy grid, and logs shots for player and computer.

Explain how to implement fire shot in a battleship VBA game: define private sub, pass parameters, determine target, update logs and borders, handle hits, misses, and sunk boats.

Add three worksheet buttons (new game, start game, fire) with ActiveX or form controls and connect them to VBA subs (do turn, start game, new game) via the developer tab.

Create and save a workbook, open and copy data from files in a directory, and use the VBA directory function with paste special options to transfer data.

Learn to read text and CSV files with Excel VBA by opening, looping to end of file, splitting lines by comma, and loading data into a worksheet.

Learn to write to text and csv files from excel vba by creating an output file, determining the last row and column, and building comma-delimited rows with print or write.

Learn to list workbook files from a directory, open each workbook, and record the file name in column A while listing each worksheet name in adjacent columns using VBA.

Finish project step by implementing load computer boats, end game logic, and dynamic button visibility in a battleship VBA game, enabling reset and replay with different grids.

Learn to build interactive VBA user interface forms, including labels, text boxes, and buttons, populate city lists, handle inputs, and append rows to an Excel table.

Create and animate a live progress bar in a VBA user form to show progress while multiplying many cells, updating the caption and the bar width as tasks advance.

Build a password form in Excel VBA with an input and confirm field, a show/hide checkbox, and logic to validate, mask, and confirm password changes.

Create an Excel VBA file form with a text box and OK and cancel buttons to select an enemy grid (1–6), enforce two-digit file numbers, and validate inputs.

Conclude this project based excel vba course by tackling independent projects, comparing your solutions with mine, and exploring topics like string manipulation, progress bars, and Battleship for practical business applications.