Showing posts with label Puzzle. Show all posts
Showing posts with label Puzzle. Show all posts

Wednesday, January 22, 2025

Excel Crossword Generator

In this post we see how to create a free-form crossword puzzle in Excel using VBA macros. The program follows the same logic of the word search generator posted a few years back (see Word Search Generator). There is a later video about that on the YouTube channel too (link). But that was a simple and limited version though. A much better word search generator is available in this other page: Word Search Pro for Excel. But here we look into a slightly different approach that allows finding common letters to force words crossing and create the crossword in Excel.


Saturday, January 6, 2024

Excel Word Search Pro

Excel Word Search Pro is the ultimate word search generator for Microsoft Excel that allows to fully customize word search puzzles to create amazing KDP puzzle books. Word Search Pro for Excel creates puzzles of any size for themes of words and alphabet in any given language. Puzzles and solutions can be formatted as wished, solution answers being highlighted in bold, circled, or shadowed in any color or multi-color. Word Search Pro for Excel allows to save each puzzle as picture and export directly to Microsoft Word to easily create your KDP puzzle book.

Tuesday, November 28, 2023

Excel Circle Packing

Excel Circle Packing is a fun VBA application to play around with circles and try to fit them all inside the smallest possible square in Excel. The program helps players fit circles more easily by adjusting their position when near the edge of the square or avoiding overlapping with other circles when possible. Depending on the number of circles selected, packing them inside the square without looking at the solution can be quite challenging. However, if you give up, there are solutions for some of the combinations in this other page.


Saturday, August 26, 2023

Excel PixelArt Puzzle

Excel PixelArt Puzzle is a VBA program that converts a pixel art representation created in Excel into a puzzle. It does so by creating pictures for each puzzle piece out of the target range spanning the desired number of cells from the pixel art (cells represent pixels). Puzzle pieces are placed randomly on the same range or next to the pixel art. Once completed, the puzzle pieces can be moved by clicking on a piece and a position or another piece to be exchanged with. Continue reading this post to see how all that works and go down to the bottom of the post to download Excel PixelArt Puzzle.


Thursday, January 26, 2023

Excel Maze Generator Kruskal

In a previous post, we have seen how to generate a maze in Excel using VBA macros and following the randomized depth-first search algorithm. In this post, we see how to create a maze in Excel using the randomized Kruskal’s algorithm. This other method allows creating larger maze structures, faster and without halting or breaking the code. On the other hand, it renders simple maze patterns that are easier to solve compared to patterns of similar size created with randomized depth-first search. Therefore, it is often used to create much larger maze structures in Excel.


Friday, October 14, 2022

Excel Nonogram Maker and Player

Do you like logic games? In this post we see how to create nonograms in Excel using VBA macros. The macros described here and the file attached allow to create custom nonograms or generate random puzzles, and then save them to another (hidden) sheet. A different tab allows to play existing (saved) nonograms or randomly generated puzzles. The nonogram player checks the progress and allows to confirm the result or display the solution. We can also change the size of the nonogram puzzles to reach different levels of difficulty. Continue reading this post to learn how the program works and download the file to play nonograms in Excel.


Saturday, December 4, 2021

Excel Maze Generator

Let's see how to leverage a classic algorithm to create a maze in Excel using VBA macros. The method used to generate the maze follows the randomized depth-first search algorithm. The maze caving process in this version of Excel Maze Generator is visual and can be followed directly on the worksheet, in order to help readers better understand how the algorithm works.

 

Sunday, February 24, 2019

Excel Rubik Cube Puzzle

In this post we see how to create a fun game inspired in Rubik’s Cube with Excel VBA. It’s a very simple macro that gives a chance to go through some formatting properties. Additionally, we will learn to use Events to add some dynamic features to the game. Excel Rubik Cube Puzzle comes with three levels of difficulty and follows some of the algorithms the real cube does.


Saturday, December 15, 2018

Excel Word Search


In this post we see how to build a Word Search generator in Excel. It’s based on very simple VBA code and gives a chance to work with Loops and Strings. The Excel Word Search generator allows you to enter your own themes and words to produce printable-ready puzzles to resolve. The key concept to build the puzzle follows the one we learnt with Excel Sudoku Generator.



Popular Posts