Software Search, Categories and Specials Categories: Excel Add-ins / Excel Templates
Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download

 

AnalyserXL - Download

 

DownloaderXL - Download

 

Smart VBA - Download

 

TraderXL - Download

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

Some of our more popular products are below...
Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To...... | Analyzer Excel | Downloader Excel | MSSQL Migration Toolkit | Monte Carlo Add-in | Excel Costing Templates