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.

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.

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.

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.

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.

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.

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

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.

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.

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.

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.

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 to implement a change player routine in Excel VBA, capture and greet the player, and initialize the game board for a single-player setup.

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

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.