I’ve been trying to make Lottery combination generator for Mega Millions Lottery to generate
already picked numbers in a specific order rather than just generate 10 to 15 numbers that
would result in thousands combinations, and I would like to generate the numbers in specific
order using a VBA.
Specific order example:
| A | B | C | D | E | F |
| BALL 1 |BALL 2 | BALL 3 | BALL 4 |BALL 5 |MEGA BALL|
1| 04 | 05 | 33 | 45 | 55 | 01 |
2| 09 | 11 | 42 | 47 | 62 | 05 |
3| 13 | 17 | 47 | 57 | 66 | 11 |
4| | 21 | | | 71 | |
5| | | | | | |
6| | | | | | |
7| | | | | | |
8| | | | | | |
9| | | | | | |
10| | | | | | |
This extends down to F19 so when generated it should look like this.
04,05,33,45,55,01
04,05,33,45,55,05
04,05,33,45,55,11
04,05,33,45,62,01
04,05,33,45,62,05
04,05,33,45,62,11 And so on down to 13,21,47,57,71,11
The numbers to be generated is under cell P3 to T3 with Mega Ball in cell U3 and I have it going down
to cell P100003 – U100003. I have also put in 2 Active Control Buttons 1 is ‘Generate Combinations’
& the other is ‘Reset Button’ the reset button is to clear all the numbers picked & the generated
numbers, I also put in a check box for ‘Check here to play the Megaplier’ if I decide to play the
Megaplier.
In cell H14 I have ‘Number of Tickets Generated’ to show how many tickets are being generated and
in cell H19 I have ‘Total Amount to Pay More if playing Megaplier’ to show how much I need to pay
to Play.
NOTE: The range for ball 1 is 1-71, ball 2 is 2-72, ball 3 is 3-73, ball 4 is 4-74, ball 5 is 5-75
& the mega ball is 1-15.
I hoping that someone can help on making a VBA for me on this because I don’t know anything about VBA programming.
Thanks for reading & in hopes of some good responses
already picked numbers in a specific order rather than just generate 10 to 15 numbers that
would result in thousands combinations, and I would like to generate the numbers in specific
order using a VBA.
Specific order example:
| A | B | C | D | E | F |
| BALL 1 |BALL 2 | BALL 3 | BALL 4 |BALL 5 |MEGA BALL|
1| 04 | 05 | 33 | 45 | 55 | 01 |
2| 09 | 11 | 42 | 47 | 62 | 05 |
3| 13 | 17 | 47 | 57 | 66 | 11 |
4| | 21 | | | 71 | |
5| | | | | | |
6| | | | | | |
7| | | | | | |
8| | | | | | |
9| | | | | | |
10| | | | | | |
This extends down to F19 so when generated it should look like this.
04,05,33,45,55,01
04,05,33,45,55,05
04,05,33,45,55,11
04,05,33,45,62,01
04,05,33,45,62,05
04,05,33,45,62,11 And so on down to 13,21,47,57,71,11
The numbers to be generated is under cell P3 to T3 with Mega Ball in cell U3 and I have it going down
to cell P100003 – U100003. I have also put in 2 Active Control Buttons 1 is ‘Generate Combinations’
& the other is ‘Reset Button’ the reset button is to clear all the numbers picked & the generated
numbers, I also put in a check box for ‘Check here to play the Megaplier’ if I decide to play the
Megaplier.
In cell H14 I have ‘Number of Tickets Generated’ to show how many tickets are being generated and
in cell H19 I have ‘Total Amount to Pay More if playing Megaplier’ to show how much I need to pay
to Play.
NOTE: The range for ball 1 is 1-71, ball 2 is 2-72, ball 3 is 3-73, ball 4 is 4-74, ball 5 is 5-75
& the mega ball is 1-15.
I hoping that someone can help on making a VBA for me on this because I don’t know anything about VBA programming.
Thanks for reading & in hopes of some good responses
Last edited: