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.

## Leave a Reply