Built-In Functions of VBA

There are many built-in functions in VBA, but only a small number of them apply to scientific and engineering applications. Table 2.1 shows a list of just a few of them. 

Round X to n digits after decimal Round(x, n) ROUND(x, n) 

To see the entire list, click the question mark for help. Then choose Microsoft Visual Basic DocumentationA isual Basic Language Reference/Functions. The functions are grouped alphabetically. 

Also shown in Table 2.1 are the corresponding Excel functions (ones that can be accessed directly from a Worksheet). Note that the VBA functions are capitalized. Perhaps the most confusing one is Sqr for taking the square root. The corresponding Excel function is the more usual SQRT. 

Excel functions that have no VBA counterpart can be called from VBA. Eor example, if it is desired to use the Pi() function within a VBA program, the Appl ication method can be used as in the following Function  

---