Bingo Number Generator Tutorial

A brief tutorial on some of the logic and techniques behind my Bingo Number Generator for Excel. This is my first vid so I realize the text is too small to read. In that case, go to my blog and download the workbook if you want to follow along. From now on I'll make sure the text in my videos are bigger.

http://www.codeforexcelandoutlook.com/blog/

Category:

Science & Technology

Tags:

• VBA
• userform
• bingo
• tutorial
• excel

[Hampstead343]

What is the code if I only want to draw even numbers?

[JP2112JP]

@Hampstead343 In the GenerateBingo function, check the value of lNum after assigning a random number to it. If lNum Mod 2 = 1, then it's odd. Add +1 to the number to make it even.

[MrToliX]

does it works for Corel Draw?

[Hampstead343]

@JP2112JP Thanks, i've already did it, I used a boolean variable, a do...loop and radio buttons so it only selects evens or odds depending what button is selected. now I try to find a way so that it avoids a list of numbers that I write in a listbox so that it only selects numbers on the grid, as in the game show Lingo.