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.
Wednesday, January 22, 2025
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
Saturday, December 15, 2018
Excel Word Search
Popular Posts
-
In this post we see how to create Sudoku puzzles with Excel VBA macros. Excel Sudoku Generator creates completely random puzzles with three ...
-
Such a great game! In this post we learn to create the Snake game in Excel using VBA macros. There are many Excel versions of the Snake game...
-
Excel Sudoku Pro is an improved version of the Excel Sudoku Generator posted in this blog a couple of years ago ( Excel Sudoku Generator ). ...
-
Classic game! In this post we see how to create the Tic Tac Toe game in Excel using VBA macros. Despite its simplicity, Excel Tic Tac Toe is...
-
Stuck with a difficult Sudoku? Get Excel Sudoku Solver and learn the principles of solving Sudoku puzzles in Excel using VBA macros. The sol...
-
In this post we learn to make the famous Minesweeper game in Excel. It is an excellent opportunity for VBA beginners to understand FOR and D...
-
There are several ways to import data from Google Sheets into Excel. In this post we review five different methods to import data from Googl...
-
Check out the new Word Search Pro for Excel! In this post we see how to build a Word Search generator in Excel. It’s based on very simple VB...
-
This post shows how to create the Sink the Fleet Battleship game in Excel. It is a good example to work with VBA formatting, loops and con...
-
We can easily customize the Excel ribbon manually and hide certain tabs or add new tabs and buttons. However, the customization does not per...