Need help with an excel formula for drawing cards off a random number

[jamaral141989]

So I hope this makes sense. I am creating a "board game" type game in excel and one of the functions will be landing on a cell. When you are on this cell you click the checkbox to the left of it which then flips the value to true. I then have another formula generating a random number between 1 and 100 if the value is true. I would like to make cards in a separate sheet out of single cells but make about 40-50 of them maybe less. I want it to be able to pull a card(cell's) contents into another cell on another sheet. But I want it to be a random card associated with the random number generator. I can definitely make changes if this isn't possible but the point of it is to show the contents of one of the random cards.

[Kaper]

I believe it is too general question (if one can call it question at all).

Lets assume that you have some "cards" in cells A1:A50 in a Cards sheet
you can select random card by the formula

Please Login or Register  to view this content.

But ... this is "volatile" card - once you change something in the spreadsheet, the card will change.
If you want to make it permanent you cannot achieve this with formula, but you shall use VBA.

[jamaral141989]

I could definitely use VBA in this. Any suggestions if I go that route? I'm a bit new to VBA so I haven't done much with it yet.