Learn Excel VBA Macros by writing Video Games

Enable the developer ribbon in Excel, record and run macros, customize blue bold text with size 28, view generated macro code, and save as a macro-enabled workbook.

Explore the visual basic editor in excel vba, navigate the project window and code window, customize toolbars and options, and master IntelliSense and option explicit for efficient coding in modules.

Learn to create your first Excel VBA macro from scratch, including inserting and renaming a module, writing a hello world subroutine, and using the immediate window and a message box.

Explore variable and project normalization in Excel VBA by applying Hungarian notation and Camil case naming, organizing code into global, master, and developer modules for clear, reusable projects.

Learn about numeric variables in VBA: integers, longs, singles, and doubles, including declarations, range limits, and basic debugging with debug.print.

Learn how if-then and block if statements control code flow in VBA, using else and else-if branches with fruit basket examples, while debugging and stepping through execution.

Create a random integer generator in Excel VBA by using the rand function, setting a min and max range, and applying randomise for unique seeds.

Build finger guessing game in Excel VBA by generating a random number from 1 to 5, prompting a guess with an input box, and showing results in a message box.

Define and concatenate string variables with numeric values in VBA, and insert multi-line prompts using new line techniques. Apply these ideas to a fruit basket example with input boxes.

Learn how to reference Excel objects in VBA, including cells, ranges, sheets, workbooks, and named ranges. Use range and cells, with statement, and worksheet functions to compute totals.

Explore handling multiple situations in Excel VBA using select case, input boxes, and end select to map user responses to lives and grades, including case else for invalid input.

Explore boolean variables in visual basic editor by declaring a boolean, initializing to false, and updating to true when a numeric value exceeds 10, illustrating the true/false binary behavior.

Write a do until loop in Excel VBA to search a range for a player name and return its score, with safeguards against infinite loops.

Learn to use do while loops in Excel VBA to sum scores down column c while column b has data, with safeguards against infinite loops in the Visual Basic Editor.

Discover how the for... next loop forms a closed loop with a fixed start and end, using step increments to accumulate a player's score in VBA macros.

Create a VBA function that returns a long between low and high, uses randomize to ensure randomness, and can be called from a subroutine to generate numbers.

Learn how to add a title block to your code, document a random integer generator, and use description, arguments, and a changes log for version control and easier debugging.

Learn how to get player names in Excel VBA macros with an optional argument, using a hidden essentials program data worksheet, named ranges, and input validation for 1–4 players.

Continue building an Excel VBA game: prompts for each player's name, stores in the essentials sheet, assembles a welcome message with proper punctuation, and handles cancellations.

Master keeping score in Excel VBA macros by adding and subtracting points and resetting scores with two new subroutines, demonstrated through player index and score updates and tests.

Update the top ten high scores by comparing a new score. Set up a high score table in columns f and g and a save routine with temporary variables.

Learn to display the top 10 high scores in a VBA message box by formatting scores with thousand separators and aligning names and scores with a fixed-width spacer using underscores.

Create two named ranges for the game one and game loss booleans in excel vba. Write a subroutine to set these flags and test win and loss conditions.

Protect your game by using a global password to guard worksheets and workbook structure, with user interface only while code updates game data.

Protect the game user interface by adding protection code to the workbook open event, ensuring the protection runs every time the workbook is opened.

Combine all essential VBA functions into one Essentials Module, including constants and workbook open code, streamlining copying central functions from six modules into a single place.

Learn to build a hangman game in Excel VBA macros, featuring category prompts, a mystery word, guess scoring with vowels costing 50 and consonants 100, and win-lose gameplay.

Outline the hangman game in Excel VBA by detailing the user interface, backend data, phrase loading, and guess handling.

Build a hangman gameboard in Excel with VBA macros, including category and phrase boxes, misses remaining, guest letters, scores, hangman shapes, and start/guess controls.

Create the hangman back end by building two data sheets: essentials data and game data, defining named ranges, phrases, difficulty levels, and reveal order to drive dynamic shape reveals.

Create a global module for hangman in Excel VBA, declare sheet names, named ranges, and gameplay data as public constants, and share phrase, letter found, and player name across subroutines.

Set up the hangman game board in Excel VBA by checking for an active game, selecting difficulty, choosing a phrase from data, loading the game, and hiding hangman shapes.

Load hangman phrases into game by populating the text box with an optional parameter and a game-over check, then loop characters to handle punctuation, reveal letters with asterisks, and save.

Learn to capture a user guess in Excel VBA, handle single-letter or full-phrase input, update scores (consonants +100, vowels -50, wrong -100), and reveal the phrase on win.

Implement Hangman incorrect guess logic in Excel VBA, track misses, reveal Hangman parts, check for loss, and update and save scores while handling user feedback.

Learn how to implement a change player name feature in a hangman game using Excel VBA, including input, saving to the workbook, resetting the board, and updating the UI.

Learn to prepare an Excel VBA game for distribution by hiding worksheets, protecting sheets with user interface only, and locking the project with a password to guard code access.

Build a 2048 game in Excel VBA by merging same-valued tiles to reach 2048; move left or right to collide tiles, with new numbers appearing and a corner strategy.

Explore building a 2048 game: design the game board and user interface, implement the backend with input and output sequences, manage new games, moves, blanks, and win or lose checks.

Create a 4x4 2048 gameboard in excel with number cells and directional arrows (left, right, up, down) plus a scoreboard for player name, current score, high score, and moves.

Create the 2048 back end by assembling the essentials worksheet and module, adding the game data worksheet, and wiring current score and high score references.

Create a 2048 game's global module in Excel VBA, defining sheet names, named ranges, before/after variables, game condition, and color codes to drive data handling and gameplay.

Learn how to convert four numbers into a sequence in Excel VBA by building a string with select case and global variables, ready for lookup.

Define a variant variable. Use vlookup in VBA to map input sequences to outputs, handle missing values, and build four-output sequences with an array stored in global variables.

Learn to implement a change player routine in Excel VBA, capture and greet the player, and initialize the game board for a single-player setup.

Start a new game by resetting win and loss flags, clearing the 2048 board, saving the high score, and zeroing all cells and moves, with after move formatting.

Learn to implement a make a move routine in excel vba macros, using input parameters and global arrays to compute before and after values for four directions and update gameboard.

Implement the after move routine in Excel VBA to fill blanks, update number colors and scores, track moves, and detect losses using a color table and log-based color logic.

Learn to find blank cells on the Excel gameboard, load them into an array, and fill blanks with 2 or 4 using a weighted random approach, then italicize new numbers.

checks whether the game reaches a max tile of 2048 to declare a winner, sets the win flag, shows a congratulatory message with the player's name, and allows continued play.

Debug a 2048 Excel VBA game by fixing shrink to fit, assigning the show leaderboard macro, correcting range references to absolute values, and adjusting move logic order.

Hide essential data and game data sheets as very hidden so only the game board remains visible. Protect workbook structure and the VBA project with a password on open.

Create a millionaire trivia game in excel vba by building game board and backend, including questions, answer options A–D, and the correct answer, then manage scoring, walk-away, and new games.

Create a millionaire trivia gameboard layout in Excel using shapes for the question box, answer options A–D, a scoreboard, and player and bank cells, with currency formatting and precise alignment.

Create the millionaire trivia back end: build a game data sheet with questions and sections, define named ranges, and implement current question value and plateau using offset and if.

Define a VBA globals module that stores constants for the game board and game data sheets and range names for questions, previous questions, correct answer, score start, and current value.

Use Excel’s conditional formatting to color the gameboard: gray for cells less than the current value. Apply blue bold formatting when a cell value equals the current question value.

Count easy, medium, and hard questions using countif, save results to global variables, and test counts in the game data sheet with a VBA module.

Load a random, unique question from the list and populate the game board with the question text and four answers, with difficulty determined by the number of questions answered correctly.

Learn to implement four parallel VBA macros for a trivia game in Excel, handling A/B/C/D guesses, game over checks, and button assignments.

Update a game score in Excel VBA by writing score module that increments by one or drops to the last multiple of five, using a global score and select case.

Implement a check answer subroutine in Excel VBA that validates a guess, updates scores across two worksheets, handles win at 15 correct answers, and formats the winnings for display.

Learn to implement a walk away button in a VBA game: confirm user intent, save the current score and winnings, update the high score, and display a positive exit message.

Reset the millionaire trivia game by starting a new session: zero the score, clear previous data, load a new question, and assign macros to start and change player buttons.

Debug and fix Excel VBA macros by assigning macros to buttons, linking player name and bank to the current score, and testing the quiz gameplay.

Congratulations on completing objectives, mastering excel vba through game projects. Apply your skills to a job or resume with four mini games and three full games—hangman, 2048, and millionaire trivia.