# 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)```

• none

## 5. Exp VisualBasic function – Where to use?

This function can be used in: Excel 2003, Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Excel 365.

The article is a part of the list of VBA Excel functions. A list of all VBA functions can be found at this address: Excel VBA functions.