To find the hyperbolic arcsine of a number in VBA, we can use the Excel **Asinh()** worksheet function.

`WorksheetFunction.Asinh(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 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.

`WorksheetFunction.Asinh(x)`

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