Excel VBA Random Functions

Buy Today, send us your order ID, and claim over $70.00 worth of FREE software

Z Random Start

Z Random can also be used from your VBA projects, just add a reference to "Z Random" and use Z Random.Next and Z Random. NextBetween to generate random numbers, or use one of the functions to generate random variables from a probability distribution like NextPareto or NextHypergeometric.

Public Sub ShowRunningTotal()

' Re-seed ZRandom with the current time ZRandom.Seed Timer
' generate 100 poisson numbers and keep a running total

Dim runningTotal As Double
Dim counter As Integer

	For counter = 1 To 100
		runningTotal = runningTotal + ZRandom.NextPoisson(5)
	Next
	
	' show the total
	MsgBox "The total was: " & CStr(runningTotal)

End Sub

Z Random Start

More about Z Random: Continuous Distributions | Functions | A VBA Interface | Interactive User Interface | Generate Random Samples | random Sort

Z Random for Excel << Click for price Secure Payment Options 30 Day Money Back Guarantee

Instant Download and Money Back Guarantee on Most Software

Microsoft Excel - From Beginner to Expert in 6 Hours

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft