To find the arcsine, or inverse sine, of a number in VBA, we can use the Excel worksheet function **Asin()**.

`WorksheetFunction.Asin(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 arcsine of a number.

To find the arcsine of a number, we use the Excel worksheet function **Asin()**.

Below is the VBA syntax to find the inverse sine of a number.

`WorksheetFunction.Asin(x)`

The input to the **Asin()** function must be a double between -1 and 1. The return value will be a double between -pi/2 and pi/2 radians.

```
Debug.Print WorksheetFunction.Asin(0.5)
Debug.Print WorksheetFunction.Asin(0)
Debug.Print WorksheetFunction.Asin(-0.75)
'Output
0.5235987755982989
0.0
-0.848062078981481
```

## Finding the Inverse Sine of a Number in VBA

Arcsine is defined as the inverse of the sine of a number.

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

```
Debug.Print WorksheetFunction.Asin(Sin(WorksheetFunction.Pi/3))
Debug.Print WorksheetFunction.Pi/3
'Output:
1.0471975511965976
1.0471975511965976
```

Hopefully this article has been beneficial for you to understand how to use the Excel **Asin()** worksheet function in VBA to find the arcsine of a number.

## Leave a Reply