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)
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?

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.

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: