Spot It or Dobble

[ManUBlueJay]

Does any one have a VBA code that would help me create a Dobble or Spot it game.
I would like to create a game to use it as a teaching tool.
I would like an executable code that would work for 6 and 7 symbols per card
For 7 you need 43 Cards and 43 Unique sumbols (For simplicity just use number 1-43)
For 6 you need 31 Cards. and 31 Unique sumbols ( just use number 1-31)

Each card which I could just set up in a grid in Excel needs to have 1 and only 1 match to any other card.
The object is who will find there match first

 

[Rijnsent]

You could try this code: What is the algorithm to generate the cards in the game "Dobble" ( known as "Spot it" in the USA )?h -> there is a whole thread about the game with answers in multiple programming languages.

 

[ManUBlueJay]

I don't want to print them, I wanted it to generate the grid.
I just managed to do it manually, which was cumbersome but I did manage to get it correct