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.

## Leave a Reply