This is a tool to quickly create and print randomized bingo cards using Excel.
Here is the Github link for the project: https://github.com/Griffii/Alphabet_Bingo_Creator
The file includes an excel workbook with macros enabled, a script to prompt the user for what they want to print and to automatically open the workbook, create sheets, and print, and an .hta file to create the prompt window for the user.
Plus a cute little taiyaki icon.
All files are available to be viewed/code reviewed if you want to know what it does.
How To Use
Download the 'Auto_Bingo_Creator' zip file
- Keep all the files in the folder, you can unzip it wherever you want
Open the 'Run Alphabet Bingo Creator' file
- This will open a popup window
Select if you want uppercase or lowercase letters and how many pages of bingo cards you want to print
- Each page is A4 in size and has 6 small 5x5 bingo cards on it
Click 'OK'
- The scripts will run automatically and in the background, so you will not see Excel open or what will be printed before it prints
That's it!
- Each bingo card is randomly generated and should not have any repeat letters.
- The center square is randomly filled from a small selection of ASCII emoji's ("^-^", "^.^", "--", "-.-", "-", "^^", "._.")
- Every time the macro runs it should generate a new unique bingo card.
If there are any issues or you would like some other features, like mixing upper and lower case or generating number bingo cards, let me know. If there's an interest in other kinds of tools I can try and put them together. It will likely be much much faster to contact me on Github rather than the comments here. Feel free to take the code and adjust as needed on your own as well.
I have included example images of what the sheets look like when the print function is called. And what the popup window looks like.
Assuming your default printer is the one you want to use and the paper size matches it should print with no issues.
Warning
You will not be able to adjust the print settings!
Margins and sizes are set within the script, but you will only be able to use your default printer.
(As far as I know, I only have access to one printer through a USB at my school so I haven't tested any other configurations)
You also need to have excel.