Analysis Toolpak and VBA

Hey there, 

I'm tring to use the Random Number Generation function in Analysis Tookpak in my VBA code. I've added atpvbaen.xls. I am using the Random function from this library but need help on understanding the arguments it requires. (outrange, points, distribution, seed, etc). I need to understand more on these arguments.

Where can I get help on how to use these Analysis Tookpak fuctions, specifially the random number generator in VBA?

My ultimate goal is to generate random numbers according to exponential and poisson distributions. I am currently generating a random number and looking it up in Poisson and Exponential tables as a work-around.

Thanks,

Kaitlin