VBA Cosh Worksheet Function – Find Hyperbolic Cosine of Number

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

WorksheetFunction.Cosh(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 cosine of a number.

To find the hyperbolic cosine of a number, we use the Excel worksheet function Cosh().

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

WorksheetFunction.Cosh(x)

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

Debug.Print WorksheetFunction.Cosh(100)
Debug.Print WorksheetFunction.Cosh(0)
Debug.Print WorksheetFunction.Cosh(-50)

'Output:
1.3440585709080678e+43
1.0
2.592352764293536e+21

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(100)) 

'Output:
100.0

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