To get the value of Euler’s Constant e in VBA, the easiest way is to use the VBA Exp() function. Exp(1) returns the value 2.718281828459. Debug.Print Exp(1); 'Output: 2.718281828459045 In VBA, we can easily get the value of e for use in various equations and applications with the VBA math functions. To get the value […]

# VBA

## VBA Trig – Using Trigonometric Functions in VBA for Trigonometry

In VBA, we can easily do trigonometry with the many trig functions from the VBA math functions and Excel worksheet functions. In this article, you will learn about all the trigonometric functions that you can use in VBA to perform trigonometry easily. In VBA, we can easily use trigonometric functions with the help of the […]

## VBA Convert Degrees to Radians with WorksheetFunction.Radians()

To convert degrees to radians for use in trigonometric functions in VBA, the easiest way is with the Excel worksheet function Radians(). radians = WorksheetFunction.Radians(60) The VBA collection of math functions has many powerful functions which make performing certain calculations in VBA very easy. Unfortunately, VBA doesn’t have a function which converts degrees to radians, […]

## VBA Convert Radians to Degrees with WorksheetFunction.Degrees()

To convert radians to degrees for use in trigonometric functions in VBA, the easiest way is with the Excel worksheet function Degrees(). degrees = WorksheetFunction.Degrees(WorksheetFunction.Pi/2) The VBA collection of math functions has many powerful functions which make performing certain calculations in VBA very easy. Unfortunately, VBA doesn’t have a function which converts radians to degrees, […]

## VBA pi – Get Value of pi Using Excel pi Worksheet Function

To get the value of pi in VBA, the easiest way is use the Excel worksheet function Pi. WorksheetFunction.Pi returns the value 3.1415926535897939. Debug.Print WorksheetFunction.Pi 'Output: 3.1415926535897939 In VBA, we can easily get the value of pi for use in trigonometry with the VBA math functions. Unfortunately, VBA doesn’t have pi as a property or […]

## VBA Atanh Worksheet Function – Inverse Hyperbolic Arctangent of Number

To find the hyperbolic arctangent of a number in VBA, we can use the Excel Atanh() worksheet function. WorksheetFunction.Atanh(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 […]

## VBA Acosh Worksheet Function – Inverse Hyperbolic Arccosine of Number

To find the hyperbolic arccosine of a number in VBA, we can use the Excel Acosh() worksheet function. WorksheetFunction.Acosh(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 […]

## VBA Tanh Worksheet Function – Find Hyperbolic Tangent of Number

To find the hyperbolic tangent of a number in VBA, we can use the Excel Tanh() worksheet function. WorksheetFunction.Tanh(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 […]

## VBA Cosh Worksheet Function – Find Hyperbolic Cosine of Number

To find the hyperbolic cosine of a number in VBA, we can use the Excel Cosh() worksheet function. WorksheetFunction.Cosh(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 […]

## VBA Sinh Worksheet Function – Find Hyperbolic Sine of Number

To find the hyperbolic sine of a number in VBA, we can use the Excel Sinh() worksheet function. WorksheetFunction.Sinh(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 […]

## VBA Asinh Worksheet Function – Find Inverse Hyperbolic Arcsine of Number

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 […]

## 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 […]

## VBA Atn – Find Arctangent and Inverse Tangent of Number

To find the arctangent, or inverse tangent, of a number in VBA, we can use the VBA Atn() function. Atn(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. To find the arctangent of a number, we use the […]

## VBA Acos Worksheet Function – Find Arccosine of Number

To find the arccosine, or inverse cosine, of a number in VBA, we can use the Excel worksheet function Acos(). WorksheetFunction.Acos(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 […]

## VBA Tan – Find Tangent of Number in Radians Using VBA Tan() Function

To find the tangent of a number (in radians) with VBA, we can use the VBA Tan() function. Tan(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. To find the tangent of a number, or the sine divided […]

## VBA Cos – Find Cosine of Number in Radians Using VBA Cos() Function

To find the cosine of a number (in radians) with VBA, we can use the VBA Cos() function. Cos(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. To find the cosine of a number, in radians, we use […]

## VBA Asin Worksheet Function – Find Arcsine and Inverse Sine of Number

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 […]

## VBA Sin – Find Sine of Number in Radians Using VBA Sin() Function

To find the sine of a number (in radians) with VBA, we can use the VBA Sin() function. Sin(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. To find the sine of a number, in radians, we use […]

## How to Get Column Letter from Number Using an Excel VBA Macro

When dynamically creating formulas using an Excel VBA macro, being able to switch between the column letter and numbers in a loop is very important. For example, let’s say you are looping over a number of columns in a Excel VBA macro. In the example, below, it’s possible I want to create a dynamic sum […]