Hi all,

I'm a relative newbie to excel vba but have also been recently hooked. Nevertheless, I am at a loss to solve this problem:

I have developed a vocabulary revision game (yes, I'm a TEFL teacher). The clues and the answers appear on Sheet1 in columns A and B. Columns C to W are taken up with positions of spaces and hyphens and positions of which letters to reveal before a player guesses (one day I'll get around to coding these). There is a game screen userform and I have managed to make the game work as I wish except:

I'd like the order in which the clues appear to be random. In the current version, I have managed to randomise the display of clues - each time the "Reveal Clue" cmdButton is pressed an RND function runs; this, of course, leads to a repetition of clues. Is there a way of avoiding this?

I intend to share this game with colleagues and there are also userforms for users to add new words/phrases and clues. So, any solution must be able to cope with expansion.

Any help will be gratefully received.
Thanks.