PDA

View Full Version : Creating a game using Excel



mite1180
10-14-2005, 09:12 PM
Hi everyone,

I'm new on this board. I was taking a course in VBA and as a final project I chose to create a Jigsaw puzzle using Excel. The idea was to let the user select a picture of his/her choice. The picture is then divided into about 25, 16, 9 blocks based on the difficulty level and then scrambled. Best times taken to solve the puzzle are recorded.

The problem is: I can't seem to figure out a way to divide up a picture into 25 equal square blocks using Excel and VBA. If anyone can help, I would be really greatful:help

RP

johnske
10-15-2005, 01:51 AM
Hi mite1180, and welcome to VBAX,

You may've bitten off quite a bit with your choice of project. :devil:

I whipped up something to yet you started (attached). There's only four jigsaw pieces in this example and you can only move each piece left/right/up/down one move at a time and it's a bit quirky, but seeing as it's your project I'll leave it to you to iron out the bugs and expand on it. :yes

This's one idea, someone else may have another.

HTH,
John :thumb

PS: Instead of time, perhaps you could put a counter on the number of moves and score it as the least number of moves to restore the picture?