In mathematics, **Pi** is an irrational number (a decimal with no end) that is equal to roughly 3.14.

To use Pi in calculations in VBA, you can use the following syntax:

**Function MultiplyByPi(inputVal)
Dim Pi As Double
MultiplyByPi = inputVal * Application.WorksheetFunction.Pi()
End Function
**

This particular function allows you to multiply any value in Excel by Pi.

Note that ** Application.WorksheetFunction.Pi** returns the value **3.14159265358979**, which is the constant Pi accurate to 15 digits.

If you need a calculation to be more accurate than 15 digits, you can simply hard code Pi to as many digits as you would like.

The following example shows how to use this syntax in practice.

**Example: How to Use Pi in VBA**

Suppose we have the following list of values in Excel that we would like to multiply by Pi:

To do so, we can create the following function in VBA:

**Function MultiplyByPi(inputVal)
Dim Pi As Double
MultiplyByPi = inputVal * Application.WorksheetFunction.Pi()
End Function**

Once we’ve created this function, we can then type the following formula into cell **B2** to multiply the value in cell **A2** by Pi:

=MultiplyByPi(A2)

We can then click and drag this formula down to each remaining cell in column B:

Column B now shows each value in column A multiplied by Pi.

**Additional Resources**

The following tutorials explain how to perform other common tasks in VBA:

VBA: How to Sum Values in Range

VBA: How to Calculate Average Value of Range

VBA: How to Count Number of Rows in Range