VBA Atan2 Worksheet Function – Arctangent of Quotient of Two Numbers

To find the arctangent, or inverse tangent, of the quotient of two numbers in VBA, we can use the Excel worksheet function Atan2().

WorksheetFunction.Atan2(x,y)

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.

VBA gives us the ability to find the arctangent of the quotient of two numbers, where the two numbers represents the coordinates of a point (x,y). To find the arctangent of the quotient of two numbers in VBA, we use the Excel worksheet function Atan2().

Below is the VBA syntax to find the inverse tangent of the quotient of two numbers.

WorksheetFunction.Atan2(x,y)

The inputs to the Atan2(x,y) function must be a doubles. The return value will be a double between -pi and pi radians.

Debug.Print WorksheetFunction.Atan2(5,1);
Debug.Print WorksheetFunction.Atan2(0,1)
Debug.Print WorksheetFunction.Atan2(-3,7)

'Output
1.373400766945016
0.0
-0.40489178628508343

Finding the Inverse Tangent of a Number in VBA

If you are just looking to find the inverse tangent of a number in VBA, you can use the regular Atn() function in VBA.

Below is the Python syntax to find the inverse tangent of a number.

Atn(x)

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

Debug.Print Atn(5)
Debug.Print Atn(0)
Debug.Print Atn(-3)

#Output: 
1.373400766945016
0.0
-1.2490457723982544

Hopefully this article has been beneficial for you to understand how to use the Excel Atan2() worksheet function in VBA to find the arctangent of the quotient of two numbers.