# Boggle game for Excel?

#### QUINABA

##### Board Regular
Has anyone created this game for Excel?

It's a game where you locate words in a 5 row by 5 column grid of letters where letters forming the words must be adjacent to each other.

Seems like an interesting project.

### Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Cool site... Not there though, closest game to Boggle is "word finder"(I think, in terms of programming).

You guys think this can be done?

I have the idea in my head but I can't quite put it in code...

I guess the first step is to determine how many possible strings of 25 letters you can get in the 5 rows by 5 columns of letters.

Sounds cool.

Keep us posted on what you end up with.

Ta

I will need a lot of help from you guys...

I'll try to outline the steps on my free time and I'll piece together any solutions I get from you...

This could be a fun project!

Any ideas or codes from anyone that could help is welcome.

In cells A1:E5, I put in the function:
Code:
``=CHAR(RANDBETWEEN(CODE("A"),CODE("Z")))``
This gives me the 5x5 square of randomized letters. The only problem is there is no algorithm to insure that there are enough vowels being displayed.

I realize this is an older thread and there are Boggle games that are on the internet, but I still think designing/programming an Excel Boggle game is a fun challenge. Unfortunately I'm not a VBA programmer. However, the 16 (4x4) Boggle cubes are listed on http://www-cs-faculty.stanford.edu/~zelenski/boggle/106b_boggle.doc and using that as a 6x16 array I've recreated the cubes. Then use =RAND() next to each "cube". The next column RANKs the random numbers to get a variable order of the cubes. Each "cube" of the 4x4 gameboard is "=INDEX(\$I\$6:\$N\$21,P6,RANDBETWEEN(1,6))" where "P6" is the ranks (from P6-P20). This generates the random face of each cube in random locations on the board. <F9> will generate a new game board (with Calculations turned to Manual). Now I need help with the other aspects: timer, clearing the words that are entered, checking words with a dictionary. Hopefully this thread gets active again.

The simplist solution I came up with is the formula I posted previously.

I did eventually write an Excel/VBA version using the Deluxe Boggle set of cubes (5 x 5, 25 cubes). If anyone is interested in it, I can certainly provide it via email (unless some else wants to host it).

Yes, I am interested.
I put the previous code of =CHAR(RANDBETWEEN(CODE("A"),CODE("Z")))
into the cells ( in Office 2003 ), and all I got was "#NAME?" in all cells.
Work for sudoko or Sudoku ?

Ta

The simplist solution I came up with is the formula I posted previously.

I did eventually write an Excel/VBA version using the Deluxe Boggle set of cubes (5 x 5, 25 cubes). If anyone is interested in it, I can certainly provide it via email (unless some else wants to host it).

My bad! RANDBETWEEN() is part of the Analysis Toolpak. Make sure you have that add-in installed/selected.

PM me with your email addy and I'll send you my boggle program.

Replies
1
Views
156
Replies
4
Views
222
Replies
0
Views
295
Replies
8
Views
62
Replies
1
Views
123

### Forum statistics

1,203,727
Messages
6,056,991
Members
444,902
Latest member
ExerciseInFutility

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back