Creating a game using Excel

[mite1180]

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

RP

[johnske]

Hi mite1180, and welcome to VBAX,

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

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.

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

HTH,
John

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?