VBA Acosh Worksheet Function – Inverse Hyperbolic Arccosine of Number

To find the hyperbolic arccosine of a number in VBA, we can use the Excel Acosh() worksheet function.

WorksheetFunction.Acosh(x)

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 arccosine of a number.

To find the hyperbolic arccosine of a number, we can use the Excel worksheet Acosh() function.

Below is the VBA syntax to find the hyperbolic arccosine of a number.

WorksheetFunction.Acosh(x)

The input to the Acosh() worksheet function must be a double greater than or equal to 1. The return value will be a double.

Debug.Print WorksheetFunction.Acosh(5.23)
Debug.Print WorksheetFunction.Acosh(0)
Debug.Print WorksheetFunction.Acosh(-5.32)

'Output:
2.3382907483329896
0.6223625037147786
5.298292365610484

Finding the Inverse Hyperbolic Cosine of a Number in VBA

With Excel and VBA, we can also find the inverses of the common trigonometric functions. The Acosh() worksheet function allows us to find the inverse of the hyperbolic cosine of a number.

Below, we show that if we pass a number to Cosh() worksheet function and then call the Excel Acosh() worksheet function, we get back the same number.

Debug.Print WorksheetFunction.Acosh(WorksheetFunction.Cosh(10)) 

'Output:
10.0

Hopefully, this article has been beneficial for you to understand how to use the Acosh() worksheet function in VBA to find the hyperbolic cosine of a number.