Random Bingo Cards
Posted By admin On 17/07/22The printable bingo cards were created using our Excel program and the web application Bingo Maker. The following PDF files contain 50 and 100 bingo cards ready to print. They have a free center with the option “ card number in corners ” to allow a draw after the game. If you want to save paper, print the template containing fifteen cards. Create Bingo Cards with Adobe Spark Post. Put a unique spin on your next game of bingo with the fully customizable bingo card templates from Adobe Spark Post. A professionally-designed selection of bingo card templates allows you to set the tone and theme. Choose fonts, colors, and other decorative design elements to add to your bingo cards.
A couple of years ago, I posted about an Excel bingo workbook, that you could use to create a set of three cards with random numbers. It uses the INDEX and MATCH functions to pull the numbers from another sheet.
=INDEX(Numbers!$M$1:$M$15, MATCH(LARGE(
Numbers!$N$1:$N$15, ROW()-1), Numbers!$N$1:$N$15,0))
There were a few follow up workbooks, including an Excel Bingo Number Selector file from Dick Kusleika.
Horizontal Number Lists
This week, Carrie posted a comment on that article, and she wanted to adapt the bingo cards so they could be printed with Adobe InDesign. Instead of a square with 25 numbers, that program needs the 25 numbers in a single row.
Using the example in the screen shot above, the numbers in the first two rows would be arranged like this, followed by the numbers from the remaining rows:
Random Number Code
Jim Cone pitched in, and wrote some code to generate the random numbers in single rows, but it created some duplicates in the rows. Carrie didn't want an uprising in the bingo hall, so we sent Jim away to try again. 😉
It didn't take long for him to return with some code that worked correctly, so Carrie, and her Hummel figurine collecting friends, can safely play bingo this summer.
Random Bingo Cards Online
Whew! A bit later, Dick posted an update for Jim's code. It's shorter, and does the job very well.
Copy the Random Number Code
50 Free Printable Bingo Game Sheets
Thanks Jim and Dick! I'm sure Carrie appreciates the code, and maybe it will help a few other people.
To use this random number code, copy it to a regular code module in your workbook.
Then, go to a blank sheet, and run the SurelyYouCantBeSerious_R1 code.
Free Random Bingo Number Generator
______________