OT - Anyone been to the pub recently...

[Brad]

....reason I ask is because I've seen this game called Word-up which is
quite good and I thought I'd challenge myself to re-create it in one
of the office applications (fyi I'm using office 97 on NT4). Okay, I
know vba isn't really for games but once you've read my explanation of
the game you'll see that it appears quite simple.

Basically it's like scrabble but instead of placing letters on a board
you remove them by clicking on adjacent tiles and constructing words.
Then you score more points for longer words and certain characters -
add letter values together and multiply by the length of the word.

The place where I am stuck is moving the tiles around the board once a
word has been formed. In the pub game the tiles move downwards and
then to the right if there is space available but I can't figure out a
way of doing this in any of the office programs. Excel seems the
obvious place but it's delete function works towards top left and then
Access's on click features sound like a good idea but moving
cmd_buttons or txt_boxes around a form only when an adjacent one is
blank sounds like hard work.

Has anyone done something similar? Or even done exactly this? I'm
intrigued as to whether this can be done in vba or not.

Thanks in advance,

Brad

 

[Howard Kaikow]

How many tiles are on the board?

There are a number of books on game programming.
Don't know which to suggest.

Moving the tiles should not be difficult.
The hard(er) part is developing a structure, perhaps an array, to keep track
of things.