To find the hyperbolic arcsine of a number in VBA, we can use the Excel Asinh() worksheet function.
In VBA, we can easily use trigonometric functions from the collection of VBA math functions. These VBA math functions allow us to perform trigonometry easily.
Unfortunately, there is not a function in VBA to calculate the hyperbolic arcsine of a number.
To find the hyperbolic arcsine of a number, we use the Excel worksheet function Asinh().
Below is the VBA syntax to find the hyperbolic arcsine of a number.
The input to the Asinh() function must be a double. The return value will be a double.
Debug.Print WorksheetFunction.Asinh(10) Debug.Print WorksheetFunction.Asinh(0) Debug.Print WorksheetFunction.Asinh(-5.32) 'Output: 2.99822295029797 0.0 -2.3733388650599814
Finding the Inverse Hyperbolic Sine of a Number in VBA
With VBA and Excel, we can also find the inverses of the common trigonometric functions. The Asinh() worksheet function allows us to find the inverse of the hyperbolic sine of a number.
Below, we show that if we pass a number to the Excel Sinh() worksheet function and then call the Asinh() worksheet function, we get back the same number.
Debug.Print WorksheetFunction.Asinh(WorksheetFunction.Sinh(100)) 'Output: 100.0
Hopefully, this article has been beneficial for you to understand how to use the Excel Asinh() worksheet function in VBA to find the hyperbolic arcsine of a number.
Leave a Reply