Excel Rubix

Rubiks Cube
Download File

Description

This program was written by Justin, whose first major VBA project you can find here, which also looks cool.

Justin wrote that he started with Jeff's file, below, for inspiration, but 'basically remade the entire thing (although still utilizing the simple copy-paste method), and made a few improvements of my own'. I hope some of you reading this take inspiration from that, and work up improvements of your own to other files on this site, and share them back. Great work, Justin!


Rubix
Download File

Description

This program was written by Jeff.

The interface takes a little getting used to for this one. The cube is "unfolded" into a cross shape, so the four outermost faces are really all the same face of the cube. Rotate one turn along any of the possible positions by entering the number in the user input box, cell [c3].

The VBA is open for inspection, although as Jeff himself put it, there's not much there. It makes good use of Worksheet_Change, but the rotations are just a lot of Copy.PasteSpecial calls. The purpose of the Analysis tab escapes me.

If, like me, you are color-blind, it will probably be helpful to change the font on the cube's surface to make the numbers readable. Even with that, it will provide a new challenge to Rubix Cube fans. I can solve a real world cube, but this one baffles my mind. Guess my hands understand the puzzle better than my brain does!

Comments

This site's comment form has been retired -- shown below is the archived comment history from the previous site.