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


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.


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)


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


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.

Categorized in:


Last Update: March 20, 2024