Bingo Number Generator
March 15, 2009 • JP • 7 Comments • Rate This Article
In Create Bingo Cards in Excel, Excel MVP Debra Dalgleish posted a bingo card generator. Perfect for those slow work days (does anyone have those anymore?).
Check out Dick Kusleika's Bingo number selector, it's pretty slick.
I went ahead and created one myself as well.
If you wanted a formula version, here it is:
=CHOOSE(RANDBETWEEN(1,5),"B"&RANDBETWEEN(1,15),"I"&RANDBETWEEN(16,30),"N"&RANDBETWEEN(31,45),"G"&RANDBETWEEN(46,60),"O"&RANDBETWEEN(61,75))
Just keep pressing F9 to generate new numbers.
Keep in mind you will need some way to log the numbers that have already been picked. That's where the userform comes in.
The sample workbook has the formula in cell A1. To check out the userform, just run the StartForm macro in the modStart module.
Excel ·
Rate This Article:
(2 votes, average: 2.50 out of 5)
Loading ...What now?
Subscribe To The Blog
Email This Article
Follow Me On Twitter
My Facebook Page
Or just keep reading:
I'm just an average guy who writes VBA code for a living. This is my personal blog. Excel and Outlook are my thing, with a sprinkle of Access and Word here and there. Follow this space if you want to learn more about VBA. Keep Reading »
Previous Post: Get Parent Application Name
Next Post: Bingo Number Selector, Part Deux
Thanks, JP, that works well, and is faster than Dick's version with its fancy graphics. I'm sure the bingo players never look up anyway.
I'm just glad I finally got it right!
Hi JP, What about words?
trying to make a Baby shower Bingo sheet with words in each Cell. Using the standard 5 down 5 across. What would I do for that?
Jill,
Download the Buzzword Bingo worksheet and change the buzzwords to baby names.
http://www.codeforexcelandoutlook.com/BuzzwordBingo.html
HTH
I only have open office. Do you have a code for a 5×5 bingo card on that program using only numbers?
Sorry, no.