To get the value of Euler’s Constant e in VBA, the easiest way is to use the VBA Exp() function. Exp(1) returns the value 2.718281828459.
Debug.Print Exp(1);
'Output:
2.718281828459045
In VBA, we can easily get the value of e for use in various equations and applications with the VBA math functions.
To get the value of the constant e in your VBA code, you just need to call the Exp() function and pass ‘1’ to it to raise the constant e to the first power.
Below is an example of how to get Euler’s Constant in VBA.
Debug.Print Exp(1);
'Output:
2.718281828459045
Hopefully this article has been helpful for you to understand how to get the value of e from the VBA Exp() function.