Exp VBA function – How to calculate exponential value

1. Exp VBA function – Description

The Exp VBA function returns an 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.

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? The following are examples of using the Exp function in the VisualBasic 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)
VBA Excel functions - Exp VBA function
VBA Excel functions – Exp VBA function

4. VB Exp function – Additional information

  • none

5. Exp VisualBasic function – Where to use?

The function can be used in: Excel 2003, Excel 2007, Excel 2010, Excel 2013, Excel 2016.

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

Leave a comment

Your email address will not be published. Required fields are marked *

One thought on “Exp VBA function – How to calculate exponential value”

%d bloggers like this: