A
LOTTERY GAME IN EXCEL - GENERATE RANDOM NUMBERS
i have 5 numbers going cross from C2 to G2
i have to make a button that when clicked, each number in the cells i listed above change randomly.
If you could just explain what the "for loop" structure is, and how to use it, that would be great.
Thanks for your help in advance!
A VB For loop looks like this:
For i = 1 to 5
(statements)
Next i
Here i is called loop counter: the statements will be executed 5 times, and each time through the loop is called a pass i. e. if the statement looks like this:
print "Hello"
then the code will print "Hello" 5 times.
During the first pass the loop counter or variable i will be equal to 1. In the next pass it will be 2 and so on...
In the case of your problem we'll need to change the column numbers and keep the row constant since the values of the random number will be displayed in columns C2 to G2. So the columns change from C to D to E to .... G. The row 2 remains constant.
So our 'for loop' structure using the cells property will look like this:
For i = 3 To 7
RN = ("=RandBetween(1, 99)")
Cells(2, i) = RN
Next i
While the loop is in progress we'll also generate a random number between 1 and 99 using the 'RANDBETWEEN()' function and assign the generated number to an appropriate column. Therefore, when the value of
cells(2,i)=cells(2,3)
where the first number 2 represents the row and the second number 3 represents the column, the random number RN generated will be placed in cell C2 and accordingly as the loop progresses. Once the value of i reaches 7 or cell G2 the 'for loop' will be terminated since the next value of i will be 8 or cell H2 and we have coded that the loop run only upto i=7.
Also we have attached the above code to a command button. On clicking the command button every time a new set of random numbers is generated and your lottery game is ready.
Now take a pen and write down your 5 lucky numbers between 1 and 99 before you click on your command button and check to see if you have won. Invite your friends too!
Watch the video below (~9.5 MB) to learn the implementation of the lottery game in action:
How do I view and edit Microsoft Excel files on an iPad?
Inventory Soluton
How to rename and color worksheet tabs
Copy Worksheet Quickly
Criteria Range
Animations in Microsoft Excel
Create two charts at once
How to avoid errors while working in Excel
How to benefit from Microsoft Excel Templates
How to use Microsoft Excel 2007 with Word 2007 - create mail merge labels
Landscape Oriented Worksheet Template
How to-make a worksheet fit a printed page
How to make your charts more impressive
Perpetual Calendar from 1900 to 9999
How to create your own custom add-in
How to clear conditional formattng in Excel worksheets
How to speed up data entry of decimal numbers
How to change the color of the gridlines of an Excel worksheet or hide them
How to use Autosum in Multiple Worksheet Cells Quickly
How to have your free personal assistant in Mcrosoft Excel who reads out the data to you
How to use the status bar in Microsoft Excel to do a quick data analysis
How to calculate equal monthly payments or instalments using a mathematical equation
Data Forms to Enter and Edit Data
View 2 worksheets in same workbook side by side
Accessing a specific worksheet in large workbooks with multiple worksheets
Referencing a cell in another worksheet
How to perform a what-if analysis using a scrollbar form control
An interesting payroll solution
Future Value Solution in Microsoft Excel
Another Interesting Conditional Formatting Solution
DSUM and Array Formulas for addition solutions
IF Function Question
How to use command buttons on a splash screen in MS-Excel
Copy Paste Data from one Excel Worksheet to Another
How to separate comma separated values (csv) in a worksheet cell in Microsoft Excel into rows or columns
Another Interesting Solver solution in Microsoft Excel
Find duplicates in two different Excel worksheets using a macro
How to count data based on multiple criteria - countifs function
How to convert 6/5/2011 into Sunday, 6/5/2011
User Form to perform calculations
An interesting solution using conditional formatting in Microsoft Excel 2007
Show/Hide Controls on a User-Form using a Checkbox
Populate Listbox and Textboxes with Excel data using VBA and Vlookup
Protecting Specific Worksheets in an Excel Workbook using VBA
How to calculate the difference in hours between two date-time values
How do I match data from 2 worksheets and highlight the differences using MS-Excel VBA?
How to focus on a specific control (TextBox1) on a user-form in MS-Excel
Interesting sumproduct solution
COMPARE DATA LISTS USING VLOOKUP AND ISNA FUNCTIONS
VLOOKUP SOLUTION USING LIST IN MS EXCEL
How to generate random numbers in MS Excel