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.

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.

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.

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.

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.

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 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.

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.

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.

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.