Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
nyn04
' Another way a little more random see "Randomize Statement" ' vba or vb help Private Sub Label1_Click() Dim n ' Initialize random-number generator. ' Uses the system timer Randomize ' Generate random value between 1 and in this case 30. n = Int((30 * Rnd) + 1) Label1.Caption = n End Sub Good Luck TK wrote: how would I write code to generate a random number only between 1-30 say with whole nubmers such as 1,2,3, 4 etc thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help for Random Number Generation | Excel Worksheet Functions | |||
random number generation | Excel Discussion (Misc queries) | |||
random number generation | Excel Worksheet Functions | |||
I need help with random number generation | Excel Worksheet Functions | |||
random number generation | Excel Worksheet Functions |