Maths/Stats Functions - VBA
Page 1 of 1

Author:  [RJ] [ Sun Oct 04, 2015 7:46 am ]
Post subject:  Maths/Stats Functions - VBA

Hi - I downloaded a handful of the libraries (beta function, gamma function, student's T) to enable me to run some VBA code faster than before (using the excel "application.function" approach was taking up too much time).

Unfortunately - I have not been able to get all of these libraries to work once imported into VBA. There appear to be several undefined functions - a few of which I don't know how to correct.

For example: the VBA public function for the Gamma function draws on
(1) a function for Pi that I had not downloaded - but I can easily replace this; and
(2) a private function called "GammaStirF" which in turn calls on a function referred to only as "power". I'm not sure what this undefined function is - and it stops the code from running.

Grateful for any help.


Page 1 of 1 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group