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.

## Leave a Reply