I have been writing some VBA code to do some conversions for GPS data. I could probably find code for what I want to do on the web, but I am curious if anyone knows of a good reference for the basic VBA language. I ask because there are functions in Excel that I cannot seem to get in VBA.

For example, the Microsoft Excel Help chm file lists Asin as a member of WorkbookFunction object, but I get an error that it is not supported if I use it. I can, however just enter y = asin(x) and I will get the arcsin of x. In this help file, there does not seem to be any reference to functions that are available in VBA - only object members. The one that has me puzzled at the moment is INT(), which is neither a WorkbookFunction member nor an available function in VBA. I can use an If (x<0, RoundDown(x,0), RoundUp(x,0)), but I am more interested right now in finding an accurate list of functions available in VBA.

My current code is bouncing back and forth between using and not using the WorkbookFunction.trigfunction() and just the trigfunction().