If the new position leads in to an obstacle.by the number of steps indicated after first letter.Grid.Cells(settings.Cells(2, 1), settings.Cells(2, 2)) = settings.Cells(2, 3) Grid.Cells(settings.Cells(1, 1), settings.Cells(1, 2)) = settings.Cells(1, 3) If cell.Value2 "o" Then cell.ClearContents Private Sub setupGameSheet(name As String)ĭim grid As Range, settings As Range, code As Range, cell As Range Set up hot chocolate at ending position.Clear the grid contents, except when the cell has “o”.Pro tip: Just select the maze layout you want with CTRL+Select option and the type o in any cell and press CTRL+Enter to get o in all cells.Īll these os will be displayed as walls thru conditional formatting. So once a new maze is cloned (ie a new worksheet is copy pasted), simply create a maze layout by typing o into various cells. You (ie the parent) can write o in any cell inside the maze to build an obstacle there. Note: download Segoe UI Emoji font if you don’t have it. Just go to Insert > Symbol and switch the font to Segoe UI Emoji font. This has a fine collection of various emojis that you see everywhere nowadays. This font is part of all modern versions of Windows. code.start for the first cell of the code.We will create sheet specific named ranges for, Here is the basic layout of our maze front end.
You can copy a worksheet, paste it, change the settings and all the code should work just the same. Each maze can also have its own images (ie Rabbit & carrot in one maze, Kid and ice cream in another etc.).Each maze can have a different design, different starting & ending positions.There can be any number of mazes, one per spreadsheet.Since kids will be playing this, we need considerable variety of mazes. Typical Blank Maze with Snowman & Hot Chocolate loaded. Of course there will be obstacles (walls). The goal is to make snowman reach hot chocolate with a series of commands. We place a cup of hot chocolate at another point. We position a snowman at a certain point in the grid. This maze game is inspired from the Angry Birds coding game at In this post, let’s understand how to build such a game using Excel VBA.
Here is the version 1.0 of Snowman & Hot Chocolate Maze game: They loved those games … err coding exercises. So that got me thinking… why not make a game in Excel that teaches kids simple programming concepts. So the other day, I showed them where there are several coding exercises disguised as games. They are super keen to learn how computers work.
My twins (Nishanth & Nakshtra) are now almost 7.
0 kommentar(er)
