# Exp VBA function – How to calculate exponential value

Last Updated on January 11, 2023 by token

## 1. Exp VBA function – Description

The Exp VBA function returns exponential value of a number. To calculate exponential value, you should use this function. For example, exponential value from 1 is the Euler’s number ~ 2.72. You can learn how to use VBA EXP function from this article.

## 2. VBA Exp function – Syntax

```'officeinside.org
Exp (Number As Double) As Double```

Number : A numeric value used to calculate the exponential value.

Function return : Double / numeric value.

## 3. VBA Exp function – Example

How to use the Exp function in VBA Excel? Here you have examples of using the Exp function in the Visual Basic Editor.

Example 1: Example of using the Exp VBA function – result in the MsgBox window.

```'officeinside.org
Dim dblNumber As Double
dblNumber = 1
MsgBox Exp(dblNumber)```

Example 2: VBA Exp – example of a function – result in the Excel spreadsheet.

```'officeinside.org
Dim dblNumber2 As Double
dblNumber2 = 1
Range ("A1") = Exp(dblNumber)```